| From: | Rafia Sabih <rafia(dot)sabih(at)enterprisedb(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: TPC-H Q20 from 1 hour to 19 hours! |
| Date: | 2017-03-30 03:23:16 |
| Message-ID: | CAOGQiiPZa-HymP0Dz4P+VkPeJegiM8sf5BONnNhHA13r87VXbw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Mar 30, 2017 at 12:30 AM, Robert Haas <robertmhaas(at)gmail(dot)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 | Content-Type | Size |
|---|---|---|
| Q21.txt | text/plain | 9.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2017-03-30 03:31:43 | Re: sequence data type |
| Previous Message | Ideriha, Takeshi | 2017-03-30 02:57:50 | Re: [WIP] RE: DECLARE STATEMENT setting up a connection in ECPG |