On 07/08/10 07:43, Gordon Shannon wrote:
> Regarding HOT prune, I never did any updates, so I think there couldn't be
> any HOT tuples. Or does HOT prune do more than that?
Yes, HOT will also prune away DELETEd tuples. It will leave behind a
dead line pointer, so it won't stop the table from growing if you
repeatedly delete and insert, but it will slow it down significantly.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com