Hacker News Reader

I have a large production deployment that is still on 9.6 because the software depends on table inheritance. (Oh man!)

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 :)

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.

Reply on news.ycombinator.com