Re: WIP: Faster Expression Processing v4

From: Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: WIP: Faster Expression Processing v4
Date: 2017-03-13 17:10:48
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 13.03.2017 11:03, Andres Freund wrote:
> Hi,
> On 2017-03-12 05:40:51 +0100, Tomas Vondra wrote:
>> I wanted to do a bit of testing and benchmarking on this, but 0004 seems to
>> be a bit broken.
> Well, "broken" in the sense that it's already outdated, because other
> stuff that got merged.
>> The patch does not apply anymore - there are some conflicts
>> in execQual.c, but I think I fixed those. But then I ran into a bunch of
>> compile-time errors, because some of the executor nodes still reference bits
>> that were moved elsewhere.
> Updated patch attached. Note that this patch has two changes I've not
> yet evaluated performance-wise.

I got the following results at my system with Intel(R) Core(TM) i7-4770
CPU @ 3.40GHz, 16Gb RAM,
TPC-H Q1/Q6 scale 10, sharedBuffers=8Gb, pg_prewarm on lineitem table

7503 ms 1171 ms
Your patch 6420 ms 1034 ms
396 ms
249 ms
VOPS + patch 367 ms
233 ms

Konstantin Knizhnik
Postgres Professional:
The Russian Postgres Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-03-13 17:13:59 Re: PATCH: Configurable file mode mask
Previous Message Jeff Janes 2017-03-13 17:05:39 Re: scram and \password