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.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general