Robert Haas <robertmh...@gmail.com> writes: > ... It's better to have a few unnecessary > checkpoints than to risk losing somebody's data, especially since the > unnecessary checkpoints only happen with wal_level=hot_standby, but > the data loss risk exists for everyone.
Yeah, that's another point here: the benefit of the patch accrues to a different set of people than the ones paying the penalty. If you've got hot standby enabled, presumably you are replicating to at least one slave and so the prospect of data loss via WAL loss is mitigated for you. I also note that the other work done in 9.2 to reduce idle-system load did not address replication configurations at all; I think we still have time-driven wakeups in walsender and walreceiver for instance. So I'd rather revert the patch now, and consider that a better fix will be part of a future round of work to reduce the idle-system load in replication setups. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers