Re: Increasing WAL usage followed by sudden drop

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-performance(at)postgresql(dot)org>, "delongboy" <sdelong(at)saucontech(dot)com>
Subject: Re: Increasing WAL usage followed by sudden drop
Date: 2012-08-16 16:39:40
Message-ID: 502CDBFC02000025000497B2@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

-Kevin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Strahinja Kustudić 2012-08-16 19:57:41 Re: Index Bloat Problem
Previous Message delongboy 2012-08-16 16:31:51 Re: Increasing WAL usage followed by sudden drop