Re: Increasing WAL usage followed by sudden drop

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Increasing WAL usage followed by sudden drop
Дата
Msg-id 502CDBFC02000025000497B2@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Increasing WAL usage followed by sudden drop  (delongboy <sdelong@saucontech.com>)
Список pgsql-performance
delongboy <sdelong@saucontech.com> wrote:
> We are not doing anything to postgres that would cause the rise
> and drop.  Data base activity is pretty consistent.  nor are we
> doing any kind of purge.  This week the drop occurred after 6
> days.  We are thinking it must be some kind of internal postgres
> activity but we can't track it down.

Maybe autovacuum freezing tuples (which is a WAL-logged operation)
as tables periodically hit the autovacuum_freeze_max_age limit?

-Kevin


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

Предыдущее
От: delongboy
Дата:
Сообщение: Re: Increasing WAL usage followed by sudden drop
Следующее
От: Strahinja Kustudić
Дата:
Сообщение: Re: Index Bloat Problem