Re: Limit + group + join

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Limit + group + join
Дата
Msg-id 10922.1125181071@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Limit + group + join  (Mark Kirkwood <markir@paradise.net.nz>)
Ответы Re: Limit + group + join  (Mark Kirkwood <markir@paradise.net.nz>)
Список pgsql-performance
Mark Kirkwood <markir@paradise.net.nz> writes:
> joinlimit=# EXPLAIN SELECT c.id FROM c JOIN b ON c_id=c.id  GROUP BY
> c.id ORDER BY c.id DESC LIMIT 5;
> [ fails to pick an available index-scan-backward plan ]

I looked into this and found that indeed the desirable join plan was
getting generated, but it wasn't picked because query_planner didn't
have an accurate idea of how much of the join needed to be scanned to
satisfy the GROUP BY step.  I've committed some changes that hopefully
will let 8.1 be smarter about GROUP BY ... LIMIT queries.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Weird performance drop after VACUUM
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: Limit + group + join