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

От: Tom Lane
Тема: Re: [Slony1-general] WAL partition overloaded--by autovacuum?
Дата: ,
Msg-id: 784.1278618633@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: [Slony1-general] 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", )

Richard Yen <> writes:
> My concern is that--as in the original post--there were moments where 129 WAL files were generated in one minute.  Is
itplausible that this autovacuum could be responsible for this? 

That's not a particularly surprising WAL creation rate for a busy
database.  I wouldn't expect autovacuum to cause it by itself, but
that's true only because autovacuum processing is typically throttled
by autovacuum_vacuum_cost_delay.  Perhaps you had that set to zero?

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: "Joshua D. Drake"
Дата:
Сообщение: Re: performance on new linux box
От: Craig Ringer
Дата:
Сообщение: Re: Need help in performance tuning.