RE: Small performance tweak to run-time partition pruning
Imai, Yoshikazu <imai.yoshikazu@jp.fujitsu.com>
From: "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
To: 'David Rowley' <david.rowley@2ndquadrant.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2018-11-08T00:34:00Z
Lists: 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
Commits
-
Improve performance of partition pruning remapping a little.
- 34c9e455d0ef 12.0 landed