Re: planner/optimizer question

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: planner/optimizer question
Дата
Msg-id pvc290584alms4s6hurvsh5ra09ki7se1s@email.aon.at
обсуждение исходный текст
Ответ на Re: planner/optimizer question  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: planner/optimizer question  ("Gary Doades" <gpd@gpdnet.co.uk>)
Список pgsql-performance
On Wed, 28 Apr 2004 09:05:04 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> [ ... visibility information in index tuples ... ]

>Storing that information would at least double the overhead space used
>for each index tuple.  The resulting index bloat would significantly
>slow index operations by requiring more I/O.  So it's far from clear
>that this would be a win, even for those who care only about select
>speed.

While the storage overhead could be reduced to 1 bit (not a joke) we'd
still have the I/O overhead of locating and updating index tuples for
every heap tuple deleted/updated.

Servus
 Manfred

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

Предыдущее
От: Manfred Koizar
Дата:
Сообщение: Re: [HACKERS] Number of pages in a random sample
Следующее
От: Manfred Koizar
Дата:
Сообщение: Re: Simply join in PostrgeSQL takes too long