Re: Small performance tweak to run-time partition pruning - Mailing list pgsql-hackers

From David Rowley
Subject Re: Small performance tweak to run-time partition pruning
Date
Msg-id CAKJS1f-are-d8SV62jViKFgbwKcALz=tzag0mk_Q3RhS2yCwSg@mail.gmail.com
Whole thread Raw
In response to RE: Small performance tweak to run-time partition pruning  ("Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>)
Responses RE: Small performance tweak to run-time partition pruning  ("Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>)
List 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 by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: [PATCH] XLogReadRecord returns pointer to currently read page
Next
From: Alvaro Herrera
Date:
Subject: Re: pgsql: Avoid duplicate XIDs at recovery when building initialsnapshot