Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
Дата
Msg-id 472300C4.70800@enterprisedb.com
обсуждение исходный текст
Ответ на Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1  (Anton <anton200@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
Anton wrote:
> I repost here my original question "Why it no uses indexes?" (on
> partitioned table and ORDER BY indexed_field DESC LIMIT 1), if you
> mean that you miss this discussion.

As I said back then:

The planner isn't smart enough to push the "ORDER BY ... LIMIT ..."
below the append node.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

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

Предыдущее
От: Anton
Дата:
Сообщение: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Speed difference between select ... union select ... and select from partitioned_table