Re: postgres is slow on windows - Mailing list pgsql-sql

From Jayadevan M
Subject Re: postgres is slow on windows
Date
Msg-id CAFS1N4jp9W+UEpq9CVO8zfyXzG8kyj=3T9pRUGfcV_L5i5CX4A@mail.gmail.com
Whole thread Raw
In response to [MASSMAIL]postgres is slow on windows  (Nazneen Mulani <naz18mulani@gmail.com>)
Responses Re: postgres is slow on windows  (Samed YILDIRIM <samed@reddoc.net>)
List pgsql-sql


On Tue, Apr 2, 2024 at 2:54 PM Nazneen Mulani <naz18mulani@gmail.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. - 

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

Regards,
Jayadevan 

pgsql-sql by date:

Previous
From: Nazneen Mulani
Date:
Subject: [MASSMAIL]postgres is slow on windows
Next
From: Samed YILDIRIM
Date:
Subject: Re: postgres is slow on windows