Re: Unneccessary cmax in heap tuple ?

Поиск
Список
Период
Сортировка
От devik@cdi.cz
Тема Re: Unneccessary cmax in heap tuple ?
Дата
Msg-id 39F6CCB4.252706CC@cdi.cz
обсуждение исходный текст
Ответ на Doesn't anyone around here run the regression tests on patches?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Unneccessary cmax in heap tuple ?
Список pgsql-hackers
> > Why is there cmax in tuple ? cxxx is used to determine
> > if tuple was inserted/deleted by current command or
> > past command. Because one command can't both insert
> > and delete the same tuple, only something like "cupd"
> > might be needed and flag which tells you whether cupd
> > is time of insert or delete. This saves 4byte from
> > header ..
> 
> If a tuple was inserted and updated in current transaction,
> how could we judge if the tuple was valid for a given
> ScanCommandId  ?
> However there could be other improvements.

Ahh I did not know that there is need to test tuple for
validity for some past cid. I thought that we only need
to know whether tuple has been updated by current cid
to ensure that it will not be scanned again in the same
cid... Where am I wrong ?
devik




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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: --with-perl=/path/to/prefered/perl?
Следующее
От: Philip Warner
Дата:
Сообщение: Re: AW: AW: BLERe: AW: AW: relation ### modified while in use