[ADMIN] 2 server with same configuration but huge difference in performance

Поиск
Список
Период
Сортировка
От Sumeet Shukla
Тема [ADMIN] 2 server with same configuration but huge difference in performance
Дата
Msg-id CABUL134EOvvkqfoMYWQr05D+VjEVu0cuSHT8rtf-7b6QvGedXQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: [ADMIN] 2 server with same configuration but huge difference in performance
Re: [ADMIN] [PERFORM] 2 server with same configuration but huge difference in performance
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Dhandapani Shanmugam
Дата:
Сообщение: [ADMIN] native connector to Postgres
Следующее
От: Keith
Дата:
Сообщение: Re: [ADMIN] 2 server with same configuration but huge difference in performance