pgsql: Improve the documentation about commit_delay.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve the documentation about commit_delay.
Date: 2013-03-15 21:42:06
Message-ID: E1UGcO6-0000XG-Hc@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Improve the documentation about commit_delay.

Clarify the docs explaining what commit_delay does, and add a
recommendation about a useful value for it, namely half of the single-page
fsync time reported by pg_test_fsync. This is informed by testing of
the new-in-9.3 implementation of commit_delay; in prior versions it
was far harder to arrive at a useful setting.

In passing, do some wordsmithing and markup-fixing in the same general
area.

Also, change pg_test_fsync's default time-per-test from 2 seconds to 5.
The old value was about the minimum at which the results could be taken
seriously at all, and so seems a tad optimistic as a default.

Peter Geoghegan, reviewed by Noah Misch; some additional editing by me

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/70ec2f8f4392f4e3d379c2c759789d631ffeec10

Modified Files
--------------
contrib/pg_test_fsync/pg_test_fsync.c | 2 +-
doc/src/sgml/config.sgml | 9 +-
doc/src/sgml/pgtestfsync.sgml | 8 +-
doc/src/sgml/wal.sgml | 169 +++++++++++++++++++++------------
4 files changed, 118 insertions(+), 70 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2013-03-16 20:31:21 Re: pgsql: Correct tense in log message
Previous Message Tom Lane 2013-03-15 16:26:32 pgsql: Improve error reporting in code that checks for buffer refcount