Re: Small performance tweak to run-time partition pruning

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Small performance tweak to run-time partition pruning
Дата
Msg-id CAKJS1f-are-d8SV62jViKFgbwKcALz=tzag0mk_Q3RhS2yCwSg@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Small performance tweak to run-time partition pruning  ("Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>)
Ответы RE: Small performance tweak to run-time partition pruning  ("Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>)
Список pgsql-hackers
On 18 October 2018 at 16:13, Imai, Yoshikazu
<imai.yoshikazu@jp.fujitsu.com> wrote:
> The patch improves the performance about 1.3% which is less than David's
> result, but it seems still improves the performance.

Thanks for doing these benchmarks.

The speedup is small, but it becomes much more significant once other
bottlenecks are removed. More partitions may show a larger increase,
but more partitions also means that a larger range table array gets
built during ExecInitRangeTable(), which is also slow.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [PATCH] XLogReadRecord returns pointer to currently read page
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pgsql: Avoid duplicate XIDs at recovery when building initialsnapshot