Re: pg_subtrans keeps bloating up in the standby

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_subtrans keeps bloating up in the standby
Дата
Msg-id 2024.1282928918@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_subtrans keeps bloating up in the standby  (Fujii Masao <masao.fujii@gmail.com>)
Ответы Re: pg_subtrans keeps bloating up in the standby  (Fujii Masao <masao.fujii@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Dimitri Fontaine
Дата:
Сообщение: Re: CopyReadLineText optimization revisited
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: pg_subtrans keeps bloating up in the standby