Re: WIP: Faster Expression Processing and Tuple Deforming (including JIT) - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: WIP: Faster Expression Processing and Tuple Deforming (including JIT)
Date
Msg-id CAM3SWZR4OwHJrcZ+Us-=mx6BnPAWAfA4pZcLU78kjHA7DvVm0A@mail.gmail.com
Whole thread Raw
In response to WIP: Faster Expression Processing and Tuple Deforming (including JIT)  (Andres Freund <andres@anarazel.de>)
Responses Re: WIP: Faster Expression Processing and Tuple Deforming (including JIT)
List pgsql-hackers
On Mon, Dec 5, 2016 at 7:49 PM, Andres Freund <andres@anarazel.de> wrote:
> I tried to address 2) by changing the C implementation. That brings some
> measurable speedups, but it's not huge. A bigger speedup is making
> slot_getattr, slot_getsomeattrs, slot_getallattrs very trivial wrappers;
> but it's still not huge.  Finally I turned to just-in-time (JIT)
> compiling the code for tuple deforming. That doesn't save the cost of
> 1), but it gets rid of most of 2) (from ~15% to ~3% in TPCH-Q01).  The
> first part is done in 0008, the JITing in 0012.

A more complete motivating example would be nice. For example, it
would be nice to see the overall speedup for some particular TPC-H
query.


-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pgcrypto compilation error due to stack-allocated EVP_CIPHER_CTX
Next
From: Adam Brusselback
Date:
Subject: Re: Separate connection handling from backends