Re: horizontal sharding

John R Pierce <pierce@hogranch.com>

From: John R Pierce <pierce@hogranch.com>
To: pgsql-general@postgresql.org
Date: 2009-06-15T17:36:30Z
Lists: pgsql-general
Jim Mlodgenski wrote:
>
>
>     also is it possible to paritition without changing client code
>
> Yes, but it depends on the SQL in your client code. If you are just 
> using simple SQL with no stored functions, you should be able to slip 
> in either solution without changing the client code. 
>  

 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.