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
Re: Faster Updates |
Список | 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 по дате отправления: