Fujii Masao <masao(dot)fujii(at)gmail(dot)com> writes:
> On Fri, Aug 27, 2010 at 11:25 PM, Heikki Linnakangas
> <heikki(dot)linnakangas(at)enterprisedb(dot)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
In response to
pgsql-hackers by date
|Next:||From: Fujii Masao||Date: 2010-08-27 17:17:10|
|Subject: Re: pg_subtrans keeps bloating up in the standby|
|Previous:||From: Dimitri Fontaine||Date: 2010-08-27 16:21:15|
|Subject: Re: CopyReadLineText optimization revisited|