tfinneid(at)student(dot)matnat(dot)uio(dot)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