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)
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 |