19 ms·
Table inheritance sounds neat, but the limitations are so severe I've never found a case where it's better than just adding a JSON column. The manual says "The
by ken 8y ago
Table inheritance sounds neat, but the limitations are so severe I've never found a case where it's better than just adding a JSON column.
The manual says "These deficiencies [with table inheritance] will probably be fixed in some future release" -- and has since at least 2002, so I think it's safe to assume the situation will never improve.
- perlgeek 8y agoI have looked into table inheritance, and came to the same conclusion as you. Later I learned that table inheritance wasn't meant to be used for polymorphism, but rather to solve performance problems. I guess that sharded tables now fill that niche in a better way.