| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | tdev457 <idzob23(at)gmail(dot)com> |
| Cc: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Number of WAL segment |
| Date: | 2013-09-21 13:23:31 |
| Message-ID: | CAB7nPqRvtT1iS2xSor4gN467jwY8BrGD2zR28sYbBfV+x5eLbg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Sep 17, 2013 at 2:35 PM, tdev457 <idzob23(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2013-09-21 13:31:56 | Re: Number of WAL segment |
| Previous Message | Luca Ferrari | 2013-09-21 13:14:20 | Re: Partitioning V schema |