Re: very slow postgresql startup

Поиск
Список
Период
Сортировка
От Venkata Balaji N
Тема Re: very slow postgresql startup
Дата
Msg-id CAEyp7J-zWzGX35VouHhu_s=9iR0_r=u+Y8_CvRNzUYyGxD7CpA@mail.gmail.com
обсуждение исходный текст
Ответ на very slow postgresql startup  (zz_11@mail.bg)
Список pgsql-admin

After stopping my pg server with pg_ctl -m immediate stop options it take hours to startup.

With vmstat I find hi pcu and io useages.

Any idea about this problem? I think it can be pg_xlog files.

How can I debug or trace this problem?

Do you see anything suspicious in the postgresql logfiles ? That can give you a fair idea on what could be the issue.

Regards,
Venkata B N

Fujitsu Australia

В списке pgsql-admin по дате отправления:

Предыдущее
От: Nguyen Hoai Nam
Дата:
Сообщение: Re: The problem is related to concurrent resquests
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: very slow postgresql startup