Postgres Pro
Downloads
Home   >   mailing lists

formula about the number of WAL files - Mailing list pgsql-docs

From Fujii Masao
Subject formula about the number of WAL files
Date
Msg-id AANLkTik0sqru9oMZeTL4vnFkAaDYZB=-Meonv9gnroiu@mail.gmail.com
Whole thread Raw
Responses Re: formula about the number of WAL files
List pgsql-docs
Tree view 
Hi,

----------------
29.4. WAL Configuration

There will always be at least one WAL segment file, and will normally not
be more than (2 + checkpoint_completion_target) * checkpoint_segments + 1
or checkpoint_segments + wal_keep_segments + 1 files.
----------------

The above formula is wrong. The correct is

    (2 + checkpoint_completion_target) * checkpoint_segments +
wal_keep_segments + 1

The attached patch fixes this fault.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
Attachment

pgsql-docs by date:

Previous
From: Robert Haas
Date:
Subject: Re: Documenting removal of nonnullvalue() and friends
Next
From: Josh Kupershmidt
Date:
Subject: description of translate()