Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group