Re: Notification when freespaces empty

Поиск
Список
Период
Сортировка
От ITAGAKI Takahiro
Тема Re: Notification when freespaces empty
Дата
Msg-id 20050524165249.3AB4.ITAGAKI.TAKAHIRO@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: Notification when freespaces empty  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> wrote:

> > Furthermore, this patch detaches empty fsmpages then.
> Does that do anything useful though?
> I thought we don't reallocate until VACUUM time, whereupon we identify
> any empty slots and reuse them. Who cares whether we deallocate earlier?

Yes, we cannot reuse them until next VACUUM.
But I think it is a problem that FSMs keep being scanned after they are almost empty.
In such a case, most stored pages are touched whenever new pages
are requested. I intended to cut FSMs earlier in order to omit the scans.


---
ITAGAKI Takahiro
NTT Cyber Space Laboratories



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Speeding up the Postgres lexer
Следующее
От: Russell Smith
Дата:
Сообщение: Re: INSTEAD OF trigger on VIEWs