From: Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
To: pgsql-hackers@postgresql.org
Subject: Re: WIP: Faster Expression Processing v4
Date: Mon, 13 Mar 2017 20:10:48 +0300
Message-ID: <c5a92c98-08e2-2e19-0d39-bc6ea3008e70@postgrespro.ru> (raw)
In-Reply-To: <20170313080351.4g5oubxcj4xj5y7t@alap3.anarazel.de>
References: <20161206034955.bh33paeralxbtluv@alap3.anarazel.de>
<20170209003312.rr7atqepgbrf4xqe@alap3.anarazel.de>
<20170307030137.lpo4japv5oqgbqpz@alap3.anarazel.de>
<2090fd00-4dec-7b42-f700-64308958504c@2ndquadrant.com>
<20170313080351.4g5oubxcj4xj5y7t@alap3.anarazel.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
projection:
Q1
Q6
Master
7503 ms 1171 ms
Your patch 6420 ms 1034 ms
VOPS
396 ms
249 ms
VOPS + patch 367 ms
233 ms
--
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: k.knizhnik@postgrespro.ru
Subject: Re: WIP: Faster Expression Processing v4
In-Reply-To: <c5a92c98-08e2-2e19-0d39-bc6ea3008e70@postgrespro.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox