Are there any solutions based on PostgreSQL that can support distributing partitions (horizontal fragmentations) across different nodes. It doesn't need to support distributed transaction, since data inconsistent is not a critical problem in my situation.
look at skype tools, to be specific - pl/proxy was made to make this kind of things possible.