C Storm <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
