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

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: [Slony1-general] WAL partition overloaded--by autovacuum?
Дата
Msg-id 4C35E5B30200002500033284@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen <richyen@iparadigms.com>)
Ответы Re: [Slony1-general] WAL partition overloaded--by autovacuum?
Список pgsql-performance
Richard Yen <richyen@iparadigms.com> wrote:

> there were moments where 129 WAL files were generated in one
> minute.  Is it plausible that this autovacuum could be responsible
> for this?

I don't remember seeing your autovacuum and vacuum config settings,
or an answer to my question about whether there was a bulk load of a
significant portion of current data.  With agressive autovacuum
settings, hitting the freeze threshold for bulk-loaded data could do
that.

-Kevin

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

Предыдущее
От: Ryan Wexler
Дата:
Сообщение: Re: performance on new linux box
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [Slony1-general] WAL partition overloaded--by autovacuum?