On Mon, Jun 15, 2009 at 11:36 AM, John R Pierce<pierce@xxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
