Re: Faster Updates

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Faster Updates
Дата
Msg-id 16058.1149348423@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Faster Updates  (PFC <lists@peufeu.com>)
Ответы Re: Faster Updates  (Nicolai Petri <nicolai@catpipe.net>)
Re: Faster Updates  (Jim Nasby <jnasby@pervasive.com>)
Список 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 по дате отправления:

Предыдущее
От: Tino Wildenhain
Дата:
Сообщение: Re: COPY (query) TO file
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: 'CVS-Unknown' buildfarm failures?