19 ms·
Ahhh I thought the partitioning was NOT inheritance based by default after reading the partition documentation page in the PG docs[0]. More specifically the "I
by hardwaresofton 9y ago
Ahhh I thought the partitioning was NOT inheritance based by default after reading the partition documentation page in the PG docs[0]. More specifically the "Implementation using inheritance" section[1] -- I thought the default was NOT to use table inheritance, but that you could use it as an option.
[0]: https://www.postgresql.org/docs/current/static/ddl-partitioning.html https://www.postgresql.org/docs/current/static/ddl-partition...
[1]: https://www.postgresql.org/docs/current/static/ddl-partitioning.html#DDL-PARTITIONING-IMPLEMENTATION-INHERITANCE https://www.postgresql.org/docs/current/static/ddl-partition...
- anarazel 9y agoYou misunderstood me, sorry I should have been clearer. Some internals are shared between inheritance and declarative partitioning. For v10 most parts of the system (except for COPY) used the same partition exclusion logic for both forms of partitioning. Which means it was O(partitions) with a pretty high constant.