Re: Where to find information on the new HOT tables?

Le Thursday 07 February 2008 20:43:57 Bruce Momjian, vous avez écrit :
> Does the release note item on HOT need additions?

If I put the release not item on HOT here:

-=-=-=-
Heap-Only Tuples (HOT) accelerate space reuse for most UPDATEs and DELETEs
(Pavan Deolasee, with ideas from many others)

UPDATEs and DELETEs leave dead tuples behind, as do failed INSERTs. Previously
only VACUUM could reclaim space taken by dead tuples. With HOT dead tuple
space can be reclaimed at the time of INSERT or UPDATE if no changes are made
to indexed columns. This allows for more consistent performance. Also, HOT
avoids adding duplicate index entries.
-=-=-=-

I'd say it only misses the transparent & automatic precision, telling the
users they don't have anything to do about HOT: PostgreSQL is able on its own
to decide when HOT is or is not safe to use.
And I have to get it back that documentation is not verbose enough about how
HOT is working, just that you have to know where to look...

What about Alvaro's concern about manual vacuuming policies editing wrt to
HOT?

Regards,
--
dim