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

From Rafia Sabih
Subject Re: TPC-H Q20 from 1 hour to 19 hours!
Date
Msg-id CAOGQiiPZa-HymP0Dz4P+VkPeJegiM8sf5BONnNhHA13r87VXbw@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>)
List pgsql-hackers
On Thu, Mar 30, 2017 at 12:30 AM, Robert Haas <robertmhaas@gmail.com> wrote:

> I don't think the problem originates at the Merge Join, though,
> because the commit says that at is fixing semi and anti-join estimates
> - this is a plain inner join, so in theory it shouldn't change.
> However, it's a bit hard for me to piece through these plans, the
> formatting kind of got messed up - things are wrapped.  Could you
> possibly attach the plans as attachments?
>
Sure, please find attached file for the plans before and after commit.

-- 
Regards,
Rafia Sabih
EnterpriseDB: http://www.enterprisedb.com/

Attachment

pgsql-hackers by date:

Previous
From: "Ideriha, Takeshi"
Date:
Subject: Re: [WIP] RE: DECLARE STATEMENT setting up a connectionin ECPG
Next
From: Michael Paquier
Date:
Subject: Re: sequence data type