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.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