On Wed, May 19, 2010 at 11:59:04AM -0600, Scott Marlowe wrote: > I run a slony replication set with about 1000 relations. That's > pretty big. It's not too hard to manage, but we have about 50,000 > other relations in the same db and for slony 1 1.2.latest, that's an > issue, as it takes about a minute now for each table to be added to a > set. > > On Wed, May 19, 2010 at 11:12 AM, <[email protected]> wrote: > > Is there any maximum # of relations for a replication cluster and/or set? > > I?m currently using Slony I 2.0.3. Haven?t been able to spot this in the > > docs. Thanks! > >
i have 6500. i don't see any relation between number of tables and normal circumstances. but once i used slony to upgrade postgres and switchover took almost 2 hours. addititionally, if you created set with thousands of tables and then while subscribing something went wrong, slony will start from the scratch - this could be very time consuming. -- IaS _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
