On Tue, Sep 17, 2013 at 2:35 PM, tdev457 <idzob23@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
