RE: Small performance tweak to run-time partition pruning

Поиск
Список
Период
Сортировка
От Imai, Yoshikazu
Тема RE: Small performance tweak to run-time partition pruning
Дата
Msg-id 0F97FA9ABBDBE54F91744A9B37151A51210D11@g01jpexmbkw24
обсуждение исходный текст
Ответ на Re: Small performance tweak to run-time partition pruning  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: Small performance tweak to run-time partition pruning  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, Oct 22, 2018 at 8:31 PM, David Rowley wrote:
> 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.

Since I did enough tests and ISTM the patch is sophisticated,
I changed the state of this patch to "Ready for Committer".

--
Yoshikazu Imai


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Inadequate executor locking of indexes
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock