Re: TPC-H Q20 from 1 hour to 19 hours!

Поиск
Список
Период
Сортировка
От Rafia Sabih
Тема Re: TPC-H Q20 from 1 hour to 19 hours!
Дата
Msg-id CAOGQiiPZa-HymP0Dz4P+VkPeJegiM8sf5BONnNhHA13r87VXbw@mail.gmail.com
обсуждение исходный текст
Ответ на [HACKERS] TPC-H Q20 from 1 hour to 19 hours!  (Rafia Sabih <rafia.sabih@enterprisedb.com>)
Список 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/

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Ideriha, Takeshi"
Дата:
Сообщение: Re: [WIP] RE: DECLARE STATEMENT setting up a connectionin ECPG
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: sequence data type