Are there any plans to support this kind of scenario?
Ciao,
Gerhard
--
http://www.wiesinger.com/
On Wed, 20 May 2009, Merlin Moncure wrote:
On Wed, May 20, 2009 at 3:11 PM, Gerhard Wiesinger <lists@xxxxxxxxxxxxx> wrote:
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?
HOT doesn't help here...it only helps with updates and then only if
you are updating fields that are not indexed. if your table has a
rolling set of data, for example a log file...you probably want to
look at table partitioning (either manual or built in).
merlin
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
