2 server with same configuration but huge difference in performance

From: Sumeet Shukla <sumeet(dot)k(dot)shukla(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: 2 server with same configuration but huge difference in performance
Date: 2017-08-01 13:41:51
Message-ID: CABUL134EOvvkqfoMYWQr05D+VjEVu0cuSHT8rtf-7b6QvGedXQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith 2017-08-01 14:16:04 Re: 2 server with same configuration but huge difference in performance
Previous Message Dhandapani Shanmugam 2017-08-01 12:12:33 native connector to Postgres

Browse pgsql-performance by date

  From Date Subject
Next Message Keith 2017-08-01 14:16:04 Re: 2 server with same configuration but huge difference in performance
Previous Message Anthony Sotolongo 2017-08-01 13:06:17 Re: How to access data of SQL server database from PostgreSQL