Comment by yobert
7 hours ago
I have a large production deployment that is still on 9.6 because the software depends on table inheritance. (Oh man!)
7 hours ago
I have a large production deployment that is still on 9.6 because the software depends on table inheritance. (Oh man!)
For 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.
Unless 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.htm...
Our 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 :)