There's talk about making partition management easier, but I doubt it's going to be present in 9.2

You can look at PL/Proxy that makes some things related to partitioning across multiple machines easier.