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.
depesz
--
http://www.depesz.com/ - nowy, lepszy depesz