| From: | "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com> |
|---|---|
| To: | "Hale Boyes, Kevin" <Kevin(dot)HaleBoyes(at)encana(dot)com> |
| Cc: | "Chris Browne" <cbbrowne(at)acm(dot)org>, pgsql-advocacy(at)postgresql(dot)org |
| Subject: | Re: Release Notes? |
| Date: | 2007-09-17 15:58:40 |
| Message-ID: | 2e78013d0709170858p15b54d4etc71cff1c446bef0f@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-09-17 17:44:30 | PostgreSQL Conference Fall 07, all speaker slots filled! |
| Previous Message | Hale Boyes, Kevin | 2007-09-17 15:19:55 | Re: Release Notes? |