Hi, On Fri, Jun 26, 2009 at 3:22 PM, Heikki Linnakangas<[email protected]> wrote: > Are you actually seeing performance degradation caused by frequent > pg_control updates? In the simple test scenarios I've tested, pg_control > is updated only once every few WAL segments, and this with > shared_buffer=32MB. With larger shared_buffers, it happens even less > frequently.
Oh, I misunderstood about how UpdateMinRecoveryPoint() is called. ISTM that recovery is still fast unless shared_buffers is set to unreasonable value. Sorry for the noise. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
