public inbox for [email protected]help / color / mirror / Atom feed
postgres is slow on windows 3+ messages / 3 participants [nested] [flat]
* postgres is slow on windows @ 2024-04-02 09:19 Nazneen Mulani <[email protected]> 2024-04-02 10:37 ` Re: postgres is slow on windows Jayadevan M <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Nazneen Mulani @ 2024-04-02 09:19 UTC (permalink / raw) To: 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 Attachments: [image/png] posgres-settings.png (116.7K, 3-posgres-settings.png) download | view image ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgres is slow on windows 2024-04-02 09:19 postgres is slow on windows Nazneen Mulani <[email protected]> @ 2024-04-02 10:37 ` Jayadevan M <[email protected]> 2024-04-04 09:17 ` Re: postgres is slow on windows Samed YILDIRIM <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Jayadevan M @ 2024-04-02 10:37 UTC (permalink / raw) To: Nazneen Mulani <[email protected]>; +Cc: pgsql-sql On Tue, Apr 2, 2024 at 2:54 PM Nazneen Mulani <[email protected]> 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgres is slow on windows 2024-04-02 09:19 postgres is slow on windows Nazneen Mulani <[email protected]> 2024-04-02 10:37 ` Re: postgres is slow on windows Jayadevan M <[email protected]> @ 2024-04-04 09:17 ` Samed YILDIRIM <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Samed YILDIRIM @ 2024-04-04 09:17 UTC (permalink / raw) To: Jayadevan M <[email protected]>; +Cc: Nazneen Mulani <[email protected]>; pgsql-sql Hello Nazneen, You compare two setups; one is PostgreSQL 14 on Windows and the other is PostgreSQL 15 on Linux. It is really hard to make a fair comparison and reach a conclusion. You, at least, need to have the same version of PostgreSQL version on both environments. Ideally, both PostgreSQL setup should be optimised for that specific environment and characteristics of the workload. Then, it would be possible to compare them. You can check what has been changed with PostgreSQL 15. You may want to check specifically performance improvements. 🙂 https://www.postgresql.org/docs/15/release-15.html Best regards. Samed YILDIRIM On Tue, 2 Apr 2024 at 13:37, Jayadevan M <[email protected]> wrote: > > > On Tue, Apr 2, 2024 at 2:54 PM Nazneen Mulani <[email protected]> > 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 > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-04-04 09:17 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-04-02 09:19 postgres is slow on windows Nazneen Mulani <[email protected]> 2024-04-02 10:37 ` Jayadevan M <[email protected]> 2024-04-04 09:17 ` Samed YILDIRIM <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox