HOT question - insert/delete

From: Gerhard Wiesinger <lists(at)wiesinger(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: HOT question - insert/delete
Date: 2009-05-20 19:11:26
Message-ID: alpine.LFD.2.00.0905202106550.17975@bbs.intern
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harald Fuchs 2009-05-20 19:41:35 Re: Help with join syntax sought
Previous Message Magnus Hagander 2009-05-20 18:45:33 Re: Regarding visual studio 2008 build