Re: [PERFORM] 2 server with same configuration but huge difference in performance

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(dot)k(dot)shukla(at)gmail(dot)com <mailto:sumeet(dot)k(dot)shukla(at)gmail(dot)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