Re: Don't removes/recycles WAL files at all

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Don't removes/recycles WAL files at all
Дата
Msg-id 27267.1059622041@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Don't removes/recycles WAL files at all  (Michael Govorun <mike@shpion.ru>)
Список pgsql-general
Michael Govorun <mike@shpion.ru> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> There's something broken there.  Check to see why checkpoint operations
>> are not completing (look in the postmaster log for relevant error
>> messages).  Open transactions should not affect this.

> No other errors messages in my log.

Maybe you have a checkpoint process that's just stuck, and is not
getting anything done yet is preventing the postmaster from launching
new checkpoints?  Use ps to look for postmaster child processes that
have been around a long time.

I seem to recall a similar report of a stuck checkpoint a few weeks ago
... check the archives.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postgres Hanging on Inserts
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Don't removes/recycles WAL files at all