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.