Re: Getting rid of cmin and cmax - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Getting rid of cmin and cmax
Date
Msg-id 7225.1158684028@sss.pgh.pa.us
Whole thread Raw
In response to Re: Getting rid of cmin and cmax  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Getting rid of cmin and cmax  (Gregory Stark <stark@enterprisedb.com>)
Re: Getting rid of cmin and cmax  (Heikki Linnakangas <heikki@enterprisedb.com>)
Re: Getting rid of cmin and cmax  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> Frankly the whole phantom commandid thing sounds more complicated. You *still*
> need a local state data structure that *still* has to spill to disk and now
> it's much harder to characterize how large it will grow since it depends on
> arbitrary combinations of cmin and cmax.

Yeah, but it requires only one entry when a command processes
arbitrarily large numbers of tuples, so in practice it's not going to
need to spill to disk.  What Heikki wants to do will require an entry in
local memory for *each tuple* modified by a transaction.  That will ruin
performance on a regular basis.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: advisory locks (was: 8.2 beta blockers)
Next
From: "Merlin Moncure"
Date:
Subject: Re: advisory locks (was: 8.2 beta blockers)