caveats... no order for partitions

Поиск
Список
Период
Сортировка
От dmitrybabiy@gmail.com
Тема caveats... no order for partitions
Дата
Msg-id 20171127102535.1466.65945@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.3/static/ddl-partitioning.html
Description:

for queries like (selects * from ... order by logdate limit 1) you will get
worse performance, planner will search in all partitions, because it knows
match partitions constraint, but doesn't know any partitions order

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