Re: how to truncate/purge the pg_xlog directory? - Mailing list pgsql-general

From Richard Huxton
Subject Re: how to truncate/purge the pg_xlog directory?
Date
Msg-id 470F7F2C.6080206@archonet.com
Whole thread Raw
In response to Re: how to truncate/purge the pg_xlog directory?  (tfinneid@student.matnat.uio.no)
List pgsql-general
tfinneid@student.matnat.uio.no wrote:
>> As checkpoints are issued, old WAL files will either be recycled
>> (renamed) or deleted. Change the setting, then try (as user postgres)
>> issuing a "vacuum full <tbl>" followed by "SELECT pg_switch_xlog()" that
>> should recycle them quicker. That'll only get you down to 3 or 4 files
>> though - that's the minimum.
>
> Nothings changed yet, maybe I need to start using the db again before I
> something real happens...

The timestamps on the WAL files should be updated if they get recycled.
Check those.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Relyea, Mike"
Date:
Subject: Out of memory with ODBC
Next
From: Clemens Schwaighofer
Date:
Subject: Query problem