Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Release Notes?



pavan(dot)deolasee(at)gmail(dot)com ("Pavan Deolasee") writes:
> 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 have updated the Wiki with that text.  Of course, it would probably
be more efficient of time to make the change directly, cutting out
middlecritters who can misread things :-).
-- 
let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];;
http://linuxfinances.info/info/lisp.html
"I decry the current  tendency to seek  patents on algorithms.   There
are better ways to  earn a living  than to  prevent other  people from
making use of one's contributions to computer science."
-- D. E. Knuth



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group