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
