3 ms·
I have a large production deployment that is still on 9.6 because the software depends on table inheritance. (Oh man!)
by yobert 2y ago
I have a large production deployment that is still on 9.6 because the software depends on table inheritance. (Oh man!)
- mnahkies 2y agoUnless I'm mistaken table inheritance is still a thing in current PG versions, in terms of partitioning at least it's just less commonly used in favour of declarative partitioning since it's easier to manage. It's been a long time since I worked with v9.x in anger, so I could well be forgetting things though https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITIONING-USING-INHERITANCE https://www.postgresql.org/docs/current/ddl-partitioning.htm...
- yobert 2y agoOur problem isn't the inheritance feature itself-- it's the removal of the config knob `sql_inheritance` which lets you change whether inherited tables are included in queries by default or not (behavior controlled manually by the * notation). It's a goofy behavior nobody liked, but we have a mountain of SQL that depends on that knob. It's fixable... Just a pain :)
- forinti 2y agoFor a while I had a separate version 9 cluster because of one application. But it wasn't really a nuisance. Postgresql doesn't give a DBA much to worry about.