Обсуждение: caveats... no order for partitions

Поиск
Список
Период
Сортировка

caveats... no order for partitions

От
dmitrybabiy@gmail.com
Дата:
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