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

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: [HACKERS] TPC-H Q20 from 1 hour to 19 hours!
Дата
Msg-id CAH2-Wz=o7r-6p6k+OLHJR9RamY7kVXWo1=rqZ_5ftBt4_xOYNA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] TPC-H Q20 from 1 hour to 19 hours!  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
On Sun, Jun 11, 2017 at 4:10 PM, Tomas Vondra
<tomas.vondra@2ndquadrant.com> wrote:
> I do strongly recommend reading this paper analyzing choke points of
> individual TPC-H queries:
>
>     http://oai.cwi.nl/oai/asset/21424/21424B.pdf
>
> It's slightly orthogonal to the issue at hand (poor estimate in Q20 causing
> choice of inefficient plan), it's a great paper to read. I thought I've
> already posted a link to the this paper sometime in the past, but I don't
> see it in the archives.

Thanks for the tip!

The practical focus of this paper really appeals to me.

-- 
Peter Geoghegan



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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: [HACKERS] TPC-H Q20 from 1 hour to 19 hours!
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Transactional sequence stuff breaks pg_upgrade