Re: Release Notes?

["Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>]

On 9/17/07, Hale Boyes, Kevin <Kevin(dot)HaleBoyes(at)encana(dot)com> wrote:

Chris Browne wrote:
> Let me note that a pretty nice list of features is being collected
>   here: http://developer.postgresql.org/index.php/WhatsNew83

A small correction.  HOT stands for Heap Only Tuple.

Right. The text is based on stale information. HOT stands for Heap Only
Tuple and the restriction about not changing tuple length during
UPDATEs has been removed.  HOT optimizes a special but important
case where UPDATE does not change any index key columns
or columns referenced in index expressions
and predicates. HOT helps early reclaim of dead space in a table, thus
reducing the need for frequent VACUUM and reduces relation
and index bloat.

I would suggest the following README to know more details.

http://archives.postgresql.org/pgsql-patches/2007-09/msg00261.php


Thanks,
Pavan

-- 
Pavan Deolasee
EnterpriseDB     http://www.enterprisedb.com