Re: horizontal sharding

On Mon, Jun 15, 2009 at 11:36 AM, John R Pierce<pierce@hogranch.com> wrote:
> 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.

You could make something reasonably fast and partitioned with pl/proxy
and views.