postgres is slow on windows

From: Nazneen Mulani <naz18mulani(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: postgres is slow on windows
Date: 2024-04-02 09:19:36
Message-ID: CAHCBtPeBQOiGgRD4m+=aZ_1NOPO+1J=Vpjr4qY19kvcEDxh3Ug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

#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

Attachment Content-Type Size
posgres-settings.png image/png 116.7 KB

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jayadevan M 2024-04-02 10:37:22 Re: postgres is slow on windows
Previous Message Steve Midgley 2024-04-01 23:13:09 Re: help with a particular multi-table query