Re: Same-page UPDATEs in bloated tables - Mailing list pgsql-general

From Tom Lane
Subject Re: Same-page UPDATEs in bloated tables
Date
Msg-id 24849.1160940026@sss.pgh.pa.us
Whole thread Raw
In response to Re: Same-page UPDATEs in bloated tables  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Same-page UPDATEs in bloated tables
List pgsql-general
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Using the same page for an updated tuple is generally a useful
> optimization, so I don't think you have much hopes for having it
> disabled.

Especially not since there's no very reasonable way for anything as
low-level as heap_update to know that "the table is way beyond its
nominal size".  What's nominal size anyway?

Actually, the recent thinking in this area has been to try to *increase*
the usage of same-page UPDATE, so as to prevent table bloat in the first
place ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Data visibility
Next
From: Rafal Pietrak
Date:
Subject: Re: Data visibility