Sam,
* Samuel Smith (pgsql@net153.net) wrote:
> Does anyone know if there is a wishlist item for improving this in
> postgresql or is this as good as it gets for now?
It's absolutely on the todo list for PG to support declarative
partitioning and handle these cases better. There has been a good sized
thread very recently discussing how to make that happen over on the
hackers mailing list recently and while it almost certainly won't be in
the next release (expected to be 9.5, released around September or
October), it may very well be in the release the following year.
Thanks!
Stephen