Re: pg_subtrans keeps bloating up in the standby - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_subtrans keeps bloating up in the standby
Date
Msg-id 2024.1282928918@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_subtrans keeps bloating up in the standby  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: pg_subtrans keeps bloating up in the standby
List pgsql-hackers
Fujii Masao <masao.fujii@gmail.com> writes:
> On Fri, Aug 27, 2010 at 11:25 PM, Heikki Linnakangas
> <heikki.linnakangas@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?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: CopyReadLineText optimization revisited
Next
From: Fujii Masao
Date:
Subject: Re: pg_subtrans keeps bloating up in the standby