Re: Pre-allocated free space for row

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DAZ SD
Тема Re: Pre-allocated free space for row
Дата
Msg-id E1539E0ED7043848906A8FF995BDA57966FB39@m0143.s-mxs.net
обсуждение исходный текст
Ответы Re: Pre-allocated free space for row  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> > My wild guess is that deleting all index pointers for a removed
index
> > is more-or-less the same cost as creating new ones for
> > inserted/updated page.
>
> Only if you are willing to make the removal process
> recalculate the index keys from looking at the deleted tuple.

The bgwriter could "update" all columns of dead heap tuples in heap
pages
to NULL and thus also gain free space without the need to touch the
indexes.
The slot would stay used but it would need less space.

Andreas


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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: On hardcoded type aliases and typmod for user types
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Pre-allocated free space for row