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