"Brian Baquiran" <brianb@edsamail.com> writes:
> How long should I expect WAL files in $PGDATA/pg_xlog to hang around?
It depends. How long are your transactions?
The current algorithm is for each checkpoint to discard log data before
the start of the oldest transaction that was open during the last
checkpoint.
Checkpoints don't happen if nothing has happened since the last
checkpoint, so if you just sit there and watch pg_xlog then you
won't see anything disappearing. But if you're using the database then
old files should get cleaned up with reasonable promptness.
regards, tom lane
