caveats... no order for partitions

From: dmitrybabiy(at)gmail(dot)com
To: pgsql-docs(at)postgresql(dot)org
Subject: caveats... no order for partitions
Date: 2017-11-27 10:25:35
Message-ID: 20171127102535.1466.65945@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-docs by date

  From Date Subject
Next Message Daniel Gustafsson 2017-11-27 15:00:42 PARALLEL in old syntax for CREATE AGGREGATE
Previous Message Thomas Munro 2017-11-26 22:03:27 Re: MacPorts xsltproc is very slow?