C Storm <christian.storm@gmail.com> writes:
> Essentially, I'm looking for the most efficient way to break a
> database into two 'shards' based on a top level table's
> primary key. For example, split a sales database into two using a
> territory.
I think what you are looking for here is partitioning, not recursion.
PG's support for partitioned tables is a bit crude, but usable:
http://www.postgresql.org/docs/8.2/static/ddl-partitioning.html
regards, tom lane
