On Tue, Sep 17, 2013 at 2:35 PM, tdev457 <idzob23@gmail.com> wrote:
> Thanks,
> I am confused now.When checkpoint_segment is set to 3 there are 7 WAL
> segments in pg_xlog.When I set checkpoint_segments to 10 there are 11 WAL
> segments.
The maximum number of WAL files is defined by this formula:
(2 + checkpoint_completion_target) * checkpoint_segments + 1
http://www.postgresql.org/docs/8.3/static/wal-configuration.html
Note that this is a soft limit, there could be more than 3 *
checkpoint_segments + 1 for a short period.
--
Michael