Jeff Davis writes:

>The disadvantages:

one more: if you actually have m tables and n servers, you have
m x n tables in reality, which is pretty miserable scaling behavior.
i should think that rules, triggers, and embedded procedures would
explode in complexity rather rapidly.

i know i wouldn't want to administer one of these if there were a lot
of sites.

>I hope this is helpful. Let me know if there's some reason my plan won't
>work.

look at the solution in pgreplicator. site ids are embedded in the
id columns in the tables, so there only m tables, and a bit less insanity.

richard
(dropping out of this conversation, i'm unsubscribing while on vacation)

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org