Re: Automatic free space map filling

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Automatic free space map filling
Дата
Msg-id 11395.1141230732@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Automatic free space map filling  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Automatic free space map filling  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Automatic free space map filling  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> I'm not sure if I made myself clear.  The idea is that you fill the free-space 
> map early with opportunitistic entries in the hope that most updates and 
> deletes go through "soon".  That is, these entries will be invalid for a 
> short time but hopefully by the time another write looks at them, the entries 
> will have become valid.  That way you don't actually have to run vacuum on 
> these deleted rows.

How does an optimistic FSM entry avoid the need to run vacuum?  All that
will happen is that some backend will visit the page and not find usable
free space.
        regards, tom lane


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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: [PERFORM] temporary indexes
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Vacuum dead tuples that are "between"