Re: WIP: Upper planner pathification

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: WIP: Upper planner pathification
Дата
Msg-id 56D5B09C.5010405@sigaev.ru
обсуждение исходный текст
Ответ на Re: WIP: Upper planner pathification  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: WIP: Upper planner pathification  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: WIP: Upper planner pathification  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> I do not think the patch will make a lot of performance difference as-is;
> its value is more in what it will let us do later.  There are a couple of
Yep, for now on my notebook (best from 5 tries):
% pgbench -i -s 3000
% pgbench  -s 3000 -c 4 -j 4 -P 1 -T 60
HEAD    569 tps
patched 542 tps
% pgbench  -s 3000 -c 4 -j 4 -P 1 -T 60 -S
HEAD    9500 tps
patched 9458 tps

Looks close to measurement error, but may be explained increased amount of work 
for planning. Including, may be, more complicated path tree.

> this kind of optimization to chance.  But the patch is big enough already,
> so that (and a lot of other things) are getting left for later.
Agree

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/
 



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

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: PoC: Partial sort
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Re: In-core regression tests for replication, cascading, archiving, PITR, etc.