Somehow http://www.postgresql.org/docs/current/static/ddl-inherit.ht... has always stopped me from using table inheritance; you don't get unique constraints over the table and its child tables, so for example you can't have an autoincrement primary key that works safely across them all. (Disclaimer: I haven't run into large enough tables yet that I'd need partitioning).
If this constraint was lifted, table inheritance would allow some really cool things, but currently I'm too conservative to use it in production.
If this constraint was lifted, table inheritance would allow some really cool things, but currently I'm too conservative to use it in production.