MIME-Version: 1.0
In-Reply-To: 
 <CABUL134EOvvkqfoMYWQr05D+VjEVu0cuSHT8rtf-7b6QvGedXQ@mail.gmail.com>
References: 
 <CABUL134EOvvkqfoMYWQr05D+VjEVu0cuSHT8rtf-7b6QvGedXQ@mail.gmail.com>
From: Keith <keith@keithf4.com>
Date: Tue, 1 Aug 2017 10:16:04 -0400
Message-ID: 
 <CAHw75vveLeAga5_0t7ze=jMcJrX3796f9d9iLbWF2_yLyTxFBg@mail.gmail.com>
Subject: Re: 2 server with same configuration but huge difference in
 performance
To: Sumeet Shukla <sumeet.k.shukla@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>, pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary="001a113df5f812e13d0555b1cccd"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

--001a113df5f812e13d0555b1cccd
Content-Type: text/plain; charset="UTF-8"

On Tue, Aug 1, 2017 at 9:41 AM, Sumeet Shukla <sumeet.k.shukla@gmail.com>
wrote:

> Hi,
>
> I have 2 PG servers with same h/w and configuration and they are not in
> replication.
>
> On server A it takes 20 minutes to execute the script.
> On server B it takes more than 20 hours. (Seems to be stuck with create
> index and and create foreign key steps)
>
> Any guidance to troubleshoot this would be highly appreciated.
>
> Thanks & Regards,
> Sumeet Shukla
>
>
Check for long running queries on the server that is taking longer. If it's
things like CREATE INDEX or ALTER TABLE statements that are being blocked,
a transaction running on the table involved will cause those commands to be
held until those transactions complete.

If it's normal read/write queries to that are taking longer, ensure the
database statistics are up to date by running an analyze.

Keith

--001a113df5f812e13d0555b1cccd
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">=
On Tue, Aug 1, 2017 at 9:41 AM, Sumeet Shukla <span dir=3D"ltr">&lt;<a href=
=3D"mailto:sumeet.k.shukla@gmail.com" target=3D"_blank">sumeet.k.shukla@gma=
il.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"=
margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex"><div dir=3D"ltr"><font face=3D"arial, helvetica, sans-serif">Hi,</fo=
nt><div><font face=3D"arial, helvetica, sans-serif"><br></font></div><div><=
font face=3D"arial, helvetica, sans-serif">I have 2 PG servers with same h/=
w and configuration and they are not in replication.</font></div><div><font=
 face=3D"arial, helvetica, sans-serif"><br></font></div><div><font face=3D"=
arial, helvetica, sans-serif">On server A it takes 20 minutes to execute th=
e script.</font></div><div><font face=3D"arial, helvetica, sans-serif">On s=
erver B it takes more than 20 hours. (Seems to be stuck with create index a=
nd and create foreign key steps)</font></div><div><font face=3D"arial, helv=
etica, sans-serif"><br></font></div><div><font face=3D"arial, helvetica, sa=
ns-serif">Any guidance to troubleshoot this would be highly appreciated.</f=
ont></div><div><font face=3D"arial, helvetica, sans-serif"><br clear=3D"all=
"></font><div><div class=3D"m_-3961069544285622731gmail-m_-7410224711479125=
196m_-8324108367728428003gmail_signature"><div dir=3D"ltr"><div dir=3D"ltr"=
><div><font face=3D"arial, helvetica, sans-serif">Thanks &amp; Regards,</fo=
nt></div><div><font face=3D"arial, helvetica, sans-serif">Sumeet Shukla</fo=
nt></div><div style=3D"font-size:small"><br></div></div></div></div></div>
</div></div>
</blockquote></div><br><div><div>Check for long running queries on the serv=
er that is taking longer. If
 it&#39;s things like CREATE INDEX or ALTER TABLE statements that are being=
=20
blocked, a transaction running on the table involved will cause those=20
commands to be held until those transactions complete.<br><br></div>If=20
it&#39;s normal read/write queries to that are taking longer, ensure the=20
database statistics are up to date by running an analyze.<br><br></div>Keit=
h</div></div>

--001a113df5f812e13d0555b1cccd--