Re: Possible bug in vacuum redo

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: Possible bug in vacuum redo
Дата
Msg-id 3C267F2F.99D6A78E@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:
> > 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.
> 
> What about READ COMMITTED mode?  EvalPlanQual uses the t_ctid field
> to find the updated version of the row.

In READ COMMITTED mode, an app searches valid tuples first
using the snapshot taken when the query started. It never
searches already updated(to newer ones) and committed tuples
at the point when the query started. Essentially t_ctid is
only needed by the concurrently running backends.

regards,
Hiroshi Inoue


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Possible bug in vacuum redo
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Possible bug in vacuum redo