Re: Getting rid of cmin and cmax
От | Tom Lane |
---|---|
Тема | Re: Getting rid of cmin and cmax |
Дата | |
Msg-id | 7225.1158684028@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: Getting rid of cmin and cmax (Gregory Stark <stark@enterprisedb.com>) |
Ответы |
Re: Getting rid of cmin and cmax
Re: Getting rid of cmin and cmax Re: Getting rid of cmin and cmax |
Список | 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 по дате отправления: