Re: Faster Updates

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Faster Updates
Дата
Msg-id 74D04147-1378-453C-B138-E1497AC95233@pervasive.com
обсуждение исходный текст
Ответ на Re: Faster Updates  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Jun 3, 2006, at 10:27 AM, Tom Lane wrote:

> 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).

A lot of CPU overhead, which in many cases won't really matter.

If someone has interest in testing this to see what impact it has,  
how hard would it be to hack together enough code to test the base  
concept? I'm thinking only basic SELECT and UPDATE support, along  
with a means to leave a certain percentage of each page empty.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: ITAGAKI Takahiro
Дата:
Сообщение: Re: bgwriter statistics
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: 'CVS-Unknown' buildfarm failures?