I have a proof-of-concept that illustrates a way of auto-sharding a Postgres database using a patched version of PL/Proxy: http://code.google.com/p/hotrepart/ h

I have a proof-of-concept that illustrates a way of auto-sharding a Postgres database using a patched version of PL/Proxy: http://code.google.com/p/hotrepart/ http://code.google.com/p/hotrepart/ The big limitation is that your DB structure has to be hierarchical. I think a lower-level solution at the WAL level would be better.