Re: [Slony1-general] WAL partition overloaded--by autovacuum?

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: [Slony1-general] WAL partition overloaded--by autovacuum?
Дата
Msg-id 4C3441BB.5020103@catalyst.net.nz
обсуждение исходный текст
Ответ на WAL partition overloaded--by autovacuum?  (Richard Yen <richyen@iparadigms.com>)
Ответы Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen <dba@richyen.com>)
Список pgsql-performance
On 07/07/10 13:10, Richard Yen wrote:
>
> This leads me to believe that there was a sudden flurry of write activity that occurred, and the process that would
flushWAL files to /db/data/ couldn't keep up, thereby filling up the disk.  I'm wondering if anyone else out there
mightbe able to give me some insight or comments to my assessment--is it accurate?  Any input would be helpful, and
I'lltry to make necessary architectural changes to keep this from happening again. 
>

Do you have wal archiving enabled? (if so lets see your archive_command).

Cheers

Mark

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

Предыдущее
От: Yeb Havinga
Дата:
Сообщение: Re: Two different execution plan for the same request
Следующее
От: Guillaume Smet
Дата:
Сообщение: Re: Two different execution plan for the same request