On Sat, Aug 28, 2010 at 2:08 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Fujii Masao <masao.fu...@gmail.com> writes: >> On Fri, Aug 27, 2010 at 11:25 PM, Heikki Linnakangas >> <heikki.linnakan...@enterprisedb.com> wrote: >>> Hmm, agreed, seems like an oversight in hot standby. Before that, we didn't >>> update pg_subtrans during recovery, so there was no point truncating it. But >>> in hot standby, we do update it, so we need to truncate it too. > >> Yes. The attached patch changes a restartpoint so that it truncates >> pg_subtrans >> when hot standby is enabled. > > Has StartupSUBTRANS been done?
Yes. StartupXLOG calls that before bgwriter is invoked. That is, we can ensure that StartupSUBTRANS has always been done before bgwriter performs a restartpoint. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
