On Fri, 30 Nov 2007 06:32:10 -0500
Andrew Dunstan <andrew@dunslane.net> wrote:
>
>
> Simon Riggs wrote:
> >
> > - Heap-Only Tuples (HOT) accelerate space reuse for UPDATEs
> > change to
> > "Heap-Only Tuples (HOT) improve performance of frequent UPDATEs"
> >
> >
> >
>
> I think we need to qualify this, or it could be quite misleading.
> perhaps add "that don't affect indexed columns" or something like
> that.
Heap Only Tuples (HOT) improves performance for heavy update tables
where the column being updated isn't indexed?
Seems kind of long but isn't that "exactly" what it does?
Sincerely,
Joshua D. Drake
>
> cheers
>
> andrew
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 1: if posting/reading
> through Usenet, please send an appropriate subscribe-nomail command
> to majordomo@postgresql.org so that your message can get through to
> the mailing list cleanly
>