Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Haas
Subject Re: TPC-H Q20 from 1 hour to 19 hours!
Date
Msg-id CA+TgmoZMjBiA_V7prVXeA2P26oUqso7iMb5fqH-2gEZTVVZDxA@mail.gmail.com
Whole thread Raw
In response to [HACKERS] TPC-H Q20 from 1 hour to 19 hours!  (Rafia Sabih <rafia.sabih@enterprisedb.com>)
Responses Re: TPC-H Q20 from 1 hour to 19 hours!  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Tree view 
On Fri, Mar 31, 2017 at 7:53 AM, Rafia Sabih
<rafia.sabih@enterprisedb.com> wrote:
> So, it looks like in the problematic area, it is not improving much.
> Please find the attached file for the query plan of Q20 with and
> without patch. I haven't evaluated the performance of this query with
> patch.

Yeah, I don't think this patch is fixing whatever is going wrong with
Q20.  It's just a problem Tomas found while investigating that issue.
Unfortunately, I don't think we know what's really going on here yet.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: logical replication launcher crash on buildfarm
Next
From: Robert Haas
Date:
Subject: Re: crashes due to setting max_parallel_workers=0