caveats... no order for partitions

2017-11-27 Thread dmitrybabiy
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

PARALLEL in old syntax for CREATE AGGREGATE

2017-11-27 Thread Daniel Gustafsson
When looking at review comments on one of my patches, I noticed that commit 41ea0c23761 didn’t include the PARALLEL keyword for the old style CREATE AGGREGATE syntax. Since it is supported, and commit 59b71c6fe6c use it in a testcase, it seems reasonable to add something along the lines of the att