pgsql: In standby mode, respect checkpoint_segments in addition to

From: heikki(at)postgresql(dot)org (Heikki Linnakangas)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: In standby mode, respect checkpoint_segments in addition to
Date: 2010-06-09 15:04:07
Message-ID: 20100609150407.0F9867541D4@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
In standby mode, respect checkpoint_segments in addition to
checkpoint_timeout to trigger restartpoints. We used to deliberately only
do time-based restartpoints, because if checkpoint_segments is small we
would spend time doing restartpoints more often than really necessary.
But now that restartpoints are done in bgwriter, they're not as
disruptive as they used to be. Secondly, because streaming replication
stores the streamed WAL files in pg_xlog, we want to clean it up more
often to avoid running out of disk space when checkpoint_timeout is large
and checkpoint_segments small.

Patch by Fujii Masao, with some minor changes by me.

Modified Files:
--------------
pgsql/src/backend/access/transam:
xlog.c (r1.418 -> r1.419)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c?r1=1.418&r2=1.419)
pgsql/src/backend/replication:
walreceiver.c (r1.13 -> r1.14)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/replication/walreceiver.c?r1=1.13&r2=1.14)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2010-06-09 16:43:48 pgsql: Add index entry for ::, per complaint from John Gage.
Previous Message Tom Lane 2010-06-09 14:58:19 Re: pgsql: Fix connection leak in dblink when dblink_connect() or