Re: Possible bug in vacuum redo

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: Possible bug in vacuum redo
Дата
Msg-id 3C26721F.B8647815@tpf.co.jp
обсуждение исходный текст
Ответ на Re: Possible bug in vacuum redo  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Ответы Re: Possible bug in vacuum redo  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> 
> "Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> >> Another thing I am currently looking at is that I do not believe VACUUM
> >> handles tuple chain moves correctly.  It only enters the chain-moving
> >> logic if it finds a tuple that is in the *middle* of an update chain,
> >> ie, both the prior and next tuples still exist.
> >        ^^^^^
> > Isn't it *either* not *both* ?
> 
> [ reads it again ]  Oh, you're right.
> 
> Still, if WAL isn't taking care to maintain t_ctid then we have a
> problem.

I don't think it's preferable either. However there's
no problem unless there's an application which handle
the tuples containing the t_ctid link. I know few
applications(vacuum, create index ??) which handles
the tuples already updated to new ones and committed
before the transaction started.
Note that redo is executed alone. Shutdown recovery
is called after killing all backends if necessary.
Of cource there are no other backends running when
startup recovery is called.

regards,
Hiroshi Inoue


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: -lperl not checked
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Possible bug in vacuum redo