Re: [HACKERS] TPC-H Q20 from 1 hour to 19 hours! - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: [HACKERS] TPC-H Q20 from 1 hour to 19 hours!
Date
Msg-id CAH2-Wz=o7r-6p6k+OLHJR9RamY7kVXWo1=rqZ_5ftBt4_xOYNA@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] TPC-H Q20 from 1 hour to 19 hours!  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
On Sun, Jun 11, 2017 at 4:10 PM, Tomas Vondra
<tomas.vondra@2ndquadrant.com> wrote:
> I do strongly recommend reading this paper analyzing choke points of
> individual TPC-H queries:
>
>     http://oai.cwi.nl/oai/asset/21424/21424B.pdf
>
> It's slightly orthogonal to the issue at hand (poor estimate in Q20 causing
> choice of inefficient plan), it's a great paper to read. I thought I've
> already posted a link to the this paper sometime in the past, but I don't
> see it in the archives.

Thanks for the tip!

The practical focus of this paper really appeals to me.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: [HACKERS] TPC-H Q20 from 1 hour to 19 hours!
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Transactional sequence stuff breaks pg_upgrade