PostgreSQL 10: Partitions of... partitions!

Posted on Sat 20 January 2018 in Postgresql Leave a comment

PostgreSQL version 10 brings a much anticipated feature: (Native) Table Partitioning.

(Emphasis on the NATIVE, PostgreSQL supported partitioning on previous versions by other means.)

There are a few gotchas you have to keep in mind when using this new feature: No PK allowed; No ON CONFLICT clauses; etc... In my …

Continue reading