Re: postgres is slow on windows

On Tue, Apr 2, 2024 at 2:54 PM Nazneen Mulani <naz18mulani(at)gmail(dot)com> wrote:

> #A description of what you are trying to achieve and what results you expect.:
>
>
> I have installed Postgres 14 on my local laptop which is new hardware given by organization.
>
> HP EliteBook
>
> Processor 13th Gen Intel(R) Core(TM) i7-1370P 1.90 GHz
>
> Installed RAM 32,0 GB (31,6 GB usable)
>
> System type 64-bit operating system, x64-based processor
>
> OS : Windows 11 Enterprise
>
>
>
> When I am running query on local database hosted on my laptop it run very slow approx. 7 sec time it takes.
>
>
>
> While Same replica db is present on server where Postgres 15 is being used. The query execution time is 1 to 2 sec. I am running these queries with DBeaver from laptop.
>
>
>
> I wanted to understand what is the difference in windows postgres setup which is causing this delay?
>
>
>
> #PostgreSQL version number you are running: Postgres 14 on local windows OS.
>
>
>
>
>
> #How you installed PostgreSQL: With the Organization Software Centre.
>
>
>
> #Changes made to the settings in the postgresql.conf file*: *
>
> Refer attachment
>
>
> #Operating system and version: Windows 11 Enterprise
>
>
>
> #What program you're using to connect to PostgreSQL: DBeaver
>
> #Is there anything relevant or unusual in the PostgreSQL server logs?: No
>
> #For questions about any kind of error: No
>
>
>
> #What you were doing when the error happened / how to cause the error:
>
> No at all, but I had run generet_series() on another schema to have random data in tables.
>
>
> Regards,
> Nazneen
>
I would suggest comparing the query plan for both environments. -
https://www.postgresql.org/docs/current/sql-explain.html

May be shared_buffers is high enough on the server and not so on your
laptop - just a guess.

Regards,
Jayadevan