Re: Server writing short WAL files

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Server writing short WAL files
Дата
Msg-id 29860.1341525602@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Server writing short WAL files  (beamsplitter@gmail.com)
Список pgsql-general
beamsplitter@gmail.com writes:
> I'm having trouble with WAL files. Every 4th WAL file written by the server
> into pg_xlog is 24576 bytes instead of 16MB. A short WAL causes a fatal
> error during recovery.

Hm.  It's fairly hard to see how you could get into such a state to
start with, but once there was a short WAL file present in pg_xlog,
the server might keep on recycling it for re-use.  Try physically
deleting or padding out the short file.

            regards, tom lane

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

Предыдущее
От: Steven Schlansker
Дата:
Сообщение: Suboptimal query plan fixed by replacing OR with UNION
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Suboptimal query plan fixed by replacing OR with UNION