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

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: logical replication launcher crash on buildfarm
Следующее
От: Robert Haas
Дата:
Сообщение: Re: crashes due to setting max_parallel_workers=0