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

Поиск
Список
Период
Сортировка
От Richard Yen
Тема Re: [Slony1-general] WAL partition overloaded--by autovacuum?
Дата
Msg-id 628D29CA-4776-422A-A9D5-9854F480CE43@richyen.com
обсуждение исходный текст
Ответ на Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Список pgsql-performance
Sorry, I forgot to mention that archive_mode is "off" and commented out, and archive command is '' and commented out.

Thanks for following up!
-- Richard

On Jul 7, 2010, at 1:58, Mark Kirkwood <mark.kirkwood@catalyst.net.nz> wrote:

> 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
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Weird XFS WAL problem
Следующее
От: Eliot Gable
Дата:
Сообщение: Re: Highly Efficient Custom Sorting