On 08/19/2015 04:59 AM, Simon Riggs wrote: > I like the idea of a regular partitioning step because it is how you > design such tables - "lets use monthly partitions". > > This gives sanely terse syntax, rather than specifying pages and pages > of exact values in DDL.... > > PARTITION BY RANGE ON (columns) INCREMENT BY (INTERVAL '1 month' ) > START WITH value;
Oh, I like that syntax! How would it work if there were multiple columns? Maybe we don't want to allow that for this form? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers