Re: planner/optimizer question

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: planner/optimizer question
Дата
Msg-id j8nu80566omg3pne8bs1qtco2s8aeggnnq@email.aon.at
обсуждение исходный текст
Ответ на Re: planner/optimizer question  ("Gary Doades" <gpd@gpdnet.co.uk>)
Ответы Re: planner/optimizer question
Список pgsql-performance
On Wed, 28 Apr 2004 07:35:41 +0100, "Gary Doades" <gpd@gpdnet.co.uk>
wrote:
>Why is there an entry in the index for a row if the row is not valid?

Because whether a row is seen as valid or not lies in the eye of the
transaction looking at it.  Full visibility information is stored in the
heap tuple header.  The developers' consensus is that this overhead
should not be in every index tuple.

Servus
 Manfred

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

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: planner/optimizer question
Следующее
От: Suller András
Дата:
Сообщение: Re: Join problem