Subject: Re: [PERFORM] 2 server with same configuration but huge
 difference in performance
To: Keith <keith@keithf4.com>, Sumeet Shukla <sumeet.k.shukla@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>, pgsql-performance@postgresql.org
References: 
 <CABUL134EOvvkqfoMYWQr05D+VjEVu0cuSHT8rtf-7b6QvGedXQ@mail.gmail.com>
 <CAHw75vveLeAga5_0t7ze=jMcJrX3796f9d9iLbWF2_yLyTxFBg@mail.gmail.com>
From: Anthony Sotolongo <asotolongo@gmail.com>
Message-ID: <084c7a84-5035-10b7-80a0-f5c19968c485@gmail.com>
Date: Tue, 1 Aug 2017 10:21:02 -0400
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.2.1
MIME-Version: 1.0
In-Reply-To: 
 <CAHw75vveLeAga5_0t7ze=jMcJrX3796f9d9iLbWF2_yLyTxFBg@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------ACD993CF224ECD1D827D80CD"
Content-Language: es-ES
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.
--------------ACD993CF224ECD1D827D80CD
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi Sumeet Shukla

While script is running check the pg_stat_activity, this view can be util


Regards

Anthony


On 01/08/17 10:16, Keith wrote:
>
> On Tue, Aug 1, 2017 at 9:41 AM, Sumeet Shukla 
> <sumeet.k.shukla@gmail.com <mailto: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


--------------ACD993CF224ECD1D827D80CD
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p>Hi <font face="arial, helvetica, sans-serif">Sumeet Shukla</font></p>
    <p>While script is running check the pg_stat_activity, this view can
      be util</p>
    <p><br>
    </p>
    <p>Regards</p>
    <p>Anthony<br>
    </p>
    <p><br>
    </p>
    <div class="moz-cite-prefix">On 01/08/17 10:16, Keith wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAHw75vveLeAga5_0t7ze=jMcJrX3796f9d9iLbWF2_yLyTxFBg@mail.gmail.com">
      <div dir="ltr">
        <div class="gmail_extra"><br>
          <div class="gmail_quote">On Tue, Aug 1, 2017 at 9:41 AM,
            Sumeet Shukla <span dir="ltr">&lt;<a
                href="mailto:sumeet.k.shukla@gmail.com" target="_blank"
                moz-do-not-send="true">sumeet.k.shukla@gmail.com</a>&gt;</span>
            wrote:<br>
            <blockquote class="gmail_quote" style="margin:0px 0px 0px
              0.8ex;border-left:1px solid
              rgb(204,204,204);padding-left:1ex">
              <div dir="ltr"><font face="arial, helvetica, sans-serif">Hi,</font>
                <div><font face="arial, helvetica, sans-serif"><br>
                  </font></div>
                <div><font face="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="arial, helvetica, sans-serif"><br>
                  </font></div>
                <div><font face="arial, helvetica, sans-serif">On server
                    A it takes 20 minutes to execute the script.</font></div>
                <div><font face="arial, helvetica, sans-serif">On server
                    B it takes more than 20 hours. (Seems to be stuck
                    with create index and and create foreign key steps)</font></div>
                <div><font face="arial, helvetica, sans-serif"><br>
                  </font></div>
                <div><font face="arial, helvetica, sans-serif">Any
                    guidance to troubleshoot this would be highly
                    appreciated.</font></div>
                <div><font face="arial, helvetica, sans-serif"><br
                      clear="all">
                  </font>
                  <div>
                    <div
class="m_-3961069544285622731gmail-m_-7410224711479125196m_-8324108367728428003gmail_signature">
                      <div dir="ltr">
                        <div dir="ltr">
                          <div><font face="arial, helvetica, sans-serif">Thanks
                              &amp; Regards,</font></div>
                          <div><font face="arial, helvetica, sans-serif">Sumeet
                              Shukla</font></div>
                          <div style="font-size:small"><br>
                          </div>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
            </blockquote>
          </div>
          <br>
          <div>
            <div>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.<br>
              <br>
            </div>
            If it's normal read/write queries to that are taking longer,
            ensure the database statistics are up to date by running an
            analyze.<br>
            <br>
          </div>
          Keith</div>
      </div>
    </blockquote>
    <br>
  </body>
</html>

--------------ACD993CF224ECD1D827D80CD--