delongboy <sdelong(at)saucontech(dot)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?
In response to
pgsql-performance by date
|Next:||From: Strahinja Kustudić||Date: 2012-08-16 19:57:41|
|Subject: Re: Index Bloat Problem|
|Previous:||From: delongboy||Date: 2012-08-16 16:31:51|
|Subject: Re: Increasing WAL usage followed by sudden drop|