Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] 2 server with same configuration but huge difference in performance - Mailing list pgsql-admin

From Sumeet Shukla
Subject [ADMIN] 2 server with same configuration but huge difference in performance
Date
Msg-id CABUL134EOvvkqfoMYWQr05D+VjEVu0cuSHT8rtf-7b6QvGedXQ@mail.gmail.com
Whole thread Raw
Responses Re: [ADMIN] 2 server with same configuration but huge difference in performance  (Keith <keith@keithf4.com>)
Re: [ADMIN] [PERFORM] 2 server with same configuration but huge difference in performance  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Dhandapani Shanmugam
Date:
Subject: [ADMIN] native connector to Postgres
Next
From: Keith
Date:
Subject: Re: [ADMIN] 2 server with same configuration but huge difference in performance