Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rrbWO-001an3-A6 for pgsql-sql@arkaria.postgresql.org; Tue, 02 Apr 2024 10:37:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rrbWN-007OUm-CS for pgsql-sql@arkaria.postgresql.org; Tue, 02 Apr 2024 10:37:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rrbWN-007OUe-14 for pgsql-sql@lists.postgresql.org; Tue, 02 Apr 2024 10:37:39 +0000 Received: from mail-qk1-x72c.google.com ([2607:f8b0:4864:20::72c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rrbWJ-000ANW-OR for pgsql-sql@postgresql.org; Tue, 02 Apr 2024 10:37:38 +0000 Received: by mail-qk1-x72c.google.com with SMTP id af79cd13be357-78a60d10eeeso331755085a.2 for ; Tue, 02 Apr 2024 03:37:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1712054254; x=1712659054; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=2fPswOc023XAaoOTMoqGylKb26JWvvtBHwa+nP4RgiY=; b=A3v7NE+TrhmUAQ13DpSyOLbzblcxUWCL0ew9GogDsrn2eE/9JtghufaF5bQ2K6hvYC ScpN5fJP487U0qZbRjzgvKVGRzMuLXs+hkf3f0Cyg/kj3uIH+Ab4F6q6wOykJITaKqRX 3A23E8kWRmjqc4PaBrd7TgB83UKbrh8/SPkz4JT7A50s55AwscGt6C5cN8yR+alMVxOE 02aDrKyXt0crarQHito6gM1ygVTL4briGo/GAiiSJU99jUCwn2jBvgPgDTlUdzB5p2cZ 63ErsWAb5LYLtY9ak3zpjGnBWK2nAl3CBKOrR4mA1hN1i8TJxj0H5qOJp+Ef9Y0WrTUl FclA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1712054254; x=1712659054; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=2fPswOc023XAaoOTMoqGylKb26JWvvtBHwa+nP4RgiY=; b=wHRYzkETn48IsNGwHibMsvYbOeEBXhVdsgl/IyTWyW9ykcTAAWNA0LBR0RpuG3Ho8H 6X+L9zV+OfOQd+Pr3SNyWlg0jwk1RKhb14Ln/meSMX2mCIgh9zcTj/JI3Ioyr+F9vDNX 8rx8wIcWzIQO/q3L17D+FYDHQzTMGk6iQvvnDPAHNsEekTNWmT65NL87XIbukI04YEWi E14GDh4zslKcDz+zd9eLCzie7Q1b2Sf8c1aKkiY+G7TgNpYrRE3hLDTmVE/CujUav2nq fqm4sag/ELJ7sFyDhLVAgCvUutcDYk6a/AAki8Kf6pLYWa23gJ9bUzAQ5csRmsDsXiRd akDA== X-Gm-Message-State: AOJu0YxNYnJOS/F5Ndx2UL2NvR4RY2YNoEN/eiEPxqlkrNe9tv1T1Oaf ilVMhsekdJABiZtqaL8MuAeV2E0KLHV7jiCNowTL/tq2wJNu+Gh4cXbeXOvnN0hn5xHyxiZWtFz 265ogtzIIxBDkpVGg2qpYhBy+bw8= X-Google-Smtp-Source: AGHT+IEuplAOuNbot1FTyTnZKSLpEgGQ891FdrhzDi9G26k4dgoAWt4zpaH17NhCo69wgpn2LfPfzyFozNElcK+Uqmk= X-Received: by 2002:ad4:43c5:0:b0:698:ec7c:b708 with SMTP id o5-20020ad443c5000000b00698ec7cb708mr12574318qvs.5.1712054253862; Tue, 02 Apr 2024 03:37:33 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Jayadevan M Date: Tue, 2 Apr 2024 16:07:22 +0530 Message-ID: Subject: Re: postgres is slow on windows To: Nazneen Mulani Cc: pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary="000000000000a345ca06151ab1d1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a345ca06151ab1d1 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Apr 2, 2024 at 2:54=E2=80=AFPM Nazneen Mulani wrote: > #A description of what you are trying to achieve and what results you exp= ect.: > > > I have installed Postgres 14 on my local laptop which is new hardware giv= en 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 use= d. 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 w= hich 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?: N= o > > #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 rando= m 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 --000000000000a345ca06151ab1d1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Tue, Apr 2, 2024 at 2:54=E2=80=AFP= M Nazneen Mulani <naz18mulani@g= mail.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 Elite=
Book
Processor=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0 13th Gen Intel(R) Core(TM) i7-1370P=C2=A0=C2=A0 1.90 =
GHz
Installed RAM=C2=A0=C2=A0 3=
2,0 GB (31,6 GB usable)
System =
type=C2=A0=C2=A0=C2=A0=C2=A0 64-bit operating system, x64-based processor
OS : Windows 11 Enterprise
=C2=A0
When I am running query on local database hosted on my lapto= p it run very slow approx. 7 sec time it takes.<= pre style=3D"font-size:10pt;margin:0cm 0cm 0.0001pt;font-family:"couri= er new";line-height:13.2pt;background-image:initial;background-positio= n:initial;background-size:initial;background-repeat:initial;background-orig= in:initial;background-clip:initial;border:none;padding:0cm">=C2=A0
While Same replica db is presen=
t 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. =

=C2=A0
I wanted to understand what is the difference in w=
indows postgres setup which is causing this delay?
=C2=A0
#Po=
stgreSQL version number you are running: Postgres 14 on local windows OS.
=C2=A0
=C2=A0=

#How you installed PostgreSQL: With the Organization Software Centre.=

=C2=A0
#Changes made to the settings in the postgresql.conf file:=
=C2=A0 
=C2=A0Refer attachm=
ent

#Operating system and version: Windows 11 Enterprise
=C2=A0
#What program you're using to connect to PostgreSQL: DBeaver
 
#Is there anything relevan=
t or unusual in the PostgreSQL server logs?: No
 
#For ques=
tions about any kind of error: No=

=C2=A0
= 
#What you were doing when the error happened / how to cau=
se the error:
No at all, but I =
had run generet_series() on another schema to have random data in tables.

=C2=A0

= Regards,
Nazneen
I woul= d suggest comparing the query plan for both environments. -=C2=A0
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,
Jayadev= an=C2=A0
--000000000000a345ca06151ab1d1--