Re: horizontal sharding

[Jim Mlodgenski <jimmy76@xxxxxxxxx>]

what about queries that need to do joins or aggregate reporting across the partitions?!?  I can't see how that could be done transparently short of something like Oracle RAC.

 
GridSQL actually does a nice job of breaking up the query and optimizing it appropriately to handle cross node joins. There are agents running on each of the nodes that handles the inter-node communication allowing it to be transparent to the calling application. 

--

Jim Mlodgenski
EnterpriseDB (http://www.enterprisedb.com)