On Fri, Nov 6, 2009 at 4:07 PM, Scott Marlowe <[email protected]> wrote: > I have about 1500 objects in my main db, and running create set takes > about 5 seconds per table or sequence. Is this typical? Any changes > I can make in terms of cost of any slony functions or creating indexes > to make it faster? >
The most complicated one I have has about 250 tables and about 50 sequences. I don't recall it taking that long to create a set. Perhaps the time is proportional to the number of objects? Which versions of everything are you using? I run Pg 8.3 and slony1 1.2.x. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
