Re: Faster Updates - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Faster Updates
Date
Msg-id 16058.1149348423@sss.pgh.pa.us
Whole thread Raw
In response to Faster Updates  (PFC <lists@peufeu.com>)
Responses Re: Faster Updates
Re: Faster Updates
List pgsql-hackers
PFC <lists@peufeu.com> writes:
>     What do you think ?

Sounds enormously complicated and of very doubtful net win --- you're
moving a lot of overhead into SELECT in order to make UPDATE cheaper,
and on top of that the restriction to same-page will limit the
usefulness quite a lot (unless we deliberately keep pages less than
full, which costs a lot in distributed extra I/O).

Basically this is an extension of the notion of update tuple chains.
Anyone who's been around the project awhile will know that we've had
an unreasonably large number of corner-case bugs associated with tuple
chains (particularly in VACUUM FULL), so adding a second level of
complexity to 'em doesn't sound very appealing to me.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: COPY (query) TO file
Next
From: Jim Nasby
Date:
Subject: Re: 'CVS-Unknown' buildfarm failures?