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