←back to thread

Why does everyone run ancient Postgres versions?

(neon.tech)
264 points davidgomes | 2 comments | 17 Oct 24 21:23 UTC | HN request time: 0.001s | source
Show context
yobert ◴[18 Oct 24 01:08 UTC] No.41875471[source]▶
I have a large production deployment that is still on 9.6 because the software depends on table inheritance. (Oh man!)
replies(2): >>41876689 #>>41877352 #
1. mnahkies ◴[18 Oct 24 05:55 UTC] No.41876689[source]▶
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...

replies(1): >>41877142 #
2. yobert ◴[18 Oct 24 07:36 UTC] No.41877142[source]▶
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 :)