Re: Increasing WAL usage followed by sudden drop - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Increasing WAL usage followed by sudden drop
Date
Msg-id 502CDBFC02000025000497B2@gw.wicourts.gov
Whole thread Raw
In response to Re: Increasing WAL usage followed by sudden drop  (delongboy <sdelong@saucontech.com>)
List 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 by date:

Previous
From: delongboy
Date:
Subject: Re: Increasing WAL usage followed by sudden drop
Next
From: Strahinja Kustudić
Date:
Subject: Re: Index Bloat Problem