HOT question - insert/delete

Поиск
Список
Период
Сортировка
От Gerhard Wiesinger
Тема HOT question - insert/delete
Дата
Msg-id alpine.LFD.2.00.0905202106550.17975@bbs.intern
обсуждение исходный текст
Ответы Re: HOT question - insert/delete  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
Hello!

Is HOT in 8.3 used in the following scenario:
INSERT ...
DELETE ...
at the same ratio.

So for example current data is added every minute and all old data
older than 2 years are deleted.

Would the heap be bloated or is this avoided by the HOT feature of 8.3 and
nearly kept constant?

Or is vacuum still needed for this scenario?

Thnx.

Ciao,
Gerhard

--
http://www.wiesinger.com/


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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: Regarding visual studio 2008 build
Следующее
От: Harald Fuchs
Дата:
Сообщение: Re: Help with join syntax sought