public inbox for [email protected]  

help / color / mirror / Atom feed

From: Nazneen Mulani <[email protected]>
To: [email protected]
Subject: postgres is slow on windows
Date: Tue, 2 Apr 2024 11:19:36 +0200
Message-ID: <CAHCBtPeBQOiGgRD4m+=aZ_1NOPO+1J=Vpjr4qY19kvcEDxh3Ug@mail.gmail.com> (raw)

#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


Attachments:

  [image/png] posgres-settings.png (116.7K, 3-posgres-settings.png)
  download | view image

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: postgres is slow on windows
  In-Reply-To: <CAHCBtPeBQOiGgRD4m+=aZ_1NOPO+1J=Vpjr4qY19kvcEDxh3Ug@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox