Re: problems with table corruption continued

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: problems with table corruption continued
Дата
Msg-id 17925.1008704171@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: problems with table corruption continued  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
Ответы Re: problems with table corruption continued  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Список pgsql-hackers
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
>> I would say that it's incorrect for vacuum.c to assume that
>> HEAP_XMIN_COMMITTED can't become set on HEAP_MOVED_OFF/HEAP_MOVED_IN
>> tuples during the course of vacuum's processing; after all, the xmin
>> definitely does refer to a committed xact, and we can't realistically
>> assume that we know what processing will be induced by user-defined
>> index functions.  Vadim, what do you think?  How should we fix this?

> But it's incorrect for table scan to mark tuple as good neither.

Oh, that makes sense.

> Looks like we have to add checks for the case
> TransactionIdIsCurrentTransactionId(tuple->t_cmin) when
> there is HEAP_MOVED_OFF or HEAP_MOVED_IN in t_infomask to
> all HeapTupleSatisfies* in tqual.c as we do in
> HeapTupleSatisfiesDirty - note comments about uniq btree-s there.

Sounds like a plan.  Do you want to work on this, or shall I?
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: problems with table corruption continued
Следующее
От: "Brian Hirt"
Дата:
Сообщение: Re: problems with table corruption continued