Re: BUG #7902: lazy cleanup of extraneous WAL files can cause out of disk issues

On 02/26/13 09:08, Jeff Janes wrote:
>
>     They're all number of xlog based and the first one doesn't remove any,
>     that's not surprising,
>
>
> What was the state of the pg_xlog directory before you started the test?  If
> it were not full up to check_point segments * 2, (which is likely was not,
> since populating pgbench_accounts avoids WAL when not archiving), this I
> agree it is not surprising.

It always start at around 258 files.

The total WAL volume during the 10min pgbench run as evidenced by enabling an
archive command that just touches the filename is 1,972 WAL files archived, or
31G.  So, it is cleaning up or recycling about 9G, unfortunately, that's just
2G too few for a 20G filesystem.



--
Jeff Frost <jeff@pgexperts.com>
CTO, PostgreSQL Experts, Inc.
Phone: 1-888-PG-EXPRT x506
FAX: 415-762-5122
http://www.pgexperts.com/