Re: Pre-allocated free space for row

Поиск
Список
Период
Сортировка
Искать
От
Zeugswetter Andreas DAZ SD
Тема
Re: Pre-allocated free space for row
Дата
Msg-id
E1539E0ED7043848906A8FF995BDA57966FB84@m0143.s-mxs.net
Список

> > 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.
> 
> Not unless it's running a transaction (consider TOAST updates).

Ok, you could leave all toast pointers and the toast table as is.

Andreas

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Andrew - Supernews
Дата:
FAQ