Postgres Pro
Downloads
Home   >   mailing lists

Re: General queston on getting rid of unused WAL files - Mailing list pgsql-admin

From Tom Lane
Subject Re: General queston on getting rid of unused WAL files
Date
Msg-id 8318.1357697800@sss.pgh.pa.us
Whole thread Raw
In response to General queston on getting rid of unused WAL files  ("Benjamin Krajmalnik" <kraj@servoyant.com>)
Responses Re: General queston on getting rid of unused WAL files  ("Benjamin Krajmalnik" <kraj@servoyant.com>)
List pgsql-admin
Tree view 
"Benjamin Krajmalnik" <kraj@servoyant.com> writes:
> Looking at pg_xlogs, I see that postgres is sequentially reusing all of
> the available WAL files, while looking at the log file, it is recycling
> approximately 70-80 files every checkpoint, but it is not removing any
> files.

[ squint... ]  It should be removing those files until it gets under
approximately 2 * checkpoint_segments WAL files.  So, what have you
got checkpoint_segments set to?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Benjamin Krajmalnik"
Date:
Subject: General queston on getting rid of unused WAL files
Next
From: "Benjamin Krajmalnik"
Date:
Subject: Re: General queston on getting rid of unused WAL files