Postgres Pro
Downloads
Home   >   mailing lists

Re: Reducing excess files in pg_xlog - Mailing list pgsql-general

From Tom Lane
Subject Re: Reducing excess files in pg_xlog
Date
Msg-id 22416.1269276464@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reducing excess files in pg_xlog  (Thom Brown <thombrown@gmail.com>)
List pgsql-general
Tree view 
Thom Brown <thombrown@gmail.com> writes:
> I've just forced a new WAL file by writing lots of stuff to a table, then
> deleting it.  It appears to be recyling the filenames now.  The latest files
> end in DD and DE, and the earliest is DF.  Presumably these will slowly get
> eaten up until it's just down to the 3 files I've configured it for?

The expected steady state is something like 2*checkpoint_segments+1
files.  See docs.

            regards, tom lane

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: Reducing excess files in pg_xlog
Next
From: Chris Barnes
Date:
Subject: Create a function that updates the record with and timestamps