Vick Khera vivek at khera.org
Sat Nov 7 20:02:39 PST 2009
On Fri, Nov 6, 2009 at 4:07 PM, Scott Marlowe <scott.marlowe at gmail.com> 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.


More information about the Slony1-general mailing list