Postgres Pro
Downloads
Home   >   mailing lists

HOT question - insert/delete - Mailing list pgsql-general

From Gerhard Wiesinger
Subject HOT question - insert/delete
Date
Msg-id alpine.LFD.2.00.0905202106550.17975@bbs.intern
Whole thread Raw
Responses Re: HOT question - insert/delete  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Regarding visual studio 2008 build
Next
From: Harald Fuchs
Date:
Subject: Re: Help with join syntax sought