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
FAQ