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)
Ответы: Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen)
Список: pgsql-performance

Скрыть дерево обсуждения

WAL partition overloaded--by autovacuum?  (Richard Yen, )
 Re: WAL partition overloaded--by autovacuum?  (Scott Marlowe, )
  Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen, )
   Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Robert Haas, )
    Re: [Slony1-general] WAL partition overloaded--by autovacuum?  ("Kevin Grittner", )
     Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen, )
      Re: [Slony1-general] WAL partition overloaded--by autovacuum?  ("Kevin Grittner", )
       Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen, )
        Re: [Slony1-general] WAL partition overloaded--by autovacuum?  ("Kevin Grittner", )
      Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Tom Lane, )
       Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen, )
     Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Tom Lane, )
      Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen, )
   Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Greg Smith, )
 Re: WAL partition overloaded--by autovacuum?  (Scott Marlowe, )
 Re: WAL partition overloaded--by autovacuum?  (Scott Marlowe, )
 Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Mark Kirkwood, )
  Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen, )
 Re: WAL partition overloaded--by autovacuum?  ("Kevin Grittner", )

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 по дате сообщения:

От: Bruce Momjian
Дата:
Сообщение: Re: Weird XFS WAL problem
От: Richard Yen
Дата:
Сообщение: Re: [Slony1-general] WAL partition overloaded--by autovacuum?