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,  <michael at aers.ca> 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