Re: ThisTimeLineID in checkpointer and bgwriter processes

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: ThisTimeLineID in checkpointer and bgwriter processes
Дата
Msg-id CAHGQGwFk8Lcj+nomVpO_TpADT9vAmAWkbReNc+WrMdne=DC0_Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ThisTimeLineID in checkpointer and bgwriter processes  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-hackers
On Fri, Dec 21, 2012 at 2:45 AM, Heikki Linnakangas
<hlinnakangas@vmware.com> wrote:
> On 20.12.2012 18:19, Fujii Masao wrote:
>>
>> InstallXLogFileSegment() also uses ThisTimeLineID. But your recent commit
>> doesn't take care of it and prevents the standby from recycling the WAL
>> files
>> properly. Specifically, the standby recycles the WAL file to wrong name.
>
>
> A-ha, good catch. So that's actually a live bug in 9.1 and 9.2 as well:
> after the recovery target timeline has changed, restartpoints will continue
> to preallocate/recycle WAL files for the old timeline. That's otherwise
> harmless, but the useless WAL files waste space, and walreceiver will have
> to always create new files.
>
> So instead of always running with ThisTimeLineID = 0 in the checkpointer
> process, I guess we'll have to update it to the timeline being replayed,
> when creating a restartpoint.

Yes. Thanks for fixing that.

Regards,

-- 
Fujii Masao



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "McDevitt, Charles"
Дата:
Сообщение: Re: Parser Cruft in gram.y
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Parser Cruft in gram.y