Thread: caveats... no order for partitions

caveats... no order for partitions

From
dmitrybabiy@gmail.com
Date:
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