On July 29, 2004 03:26 pm, Darcy Buskermolen wrote:
> On July 28, 2004 04:19 pm, Thomas F.O'Connell wrote:
> > I'm not going to be able to send the output of the script without
> > fudging the table names, and that might be more trouble than it's
> > worth.
> >
> > Anyway, the summary should give you some idea of what I'm dealing with:
> >
> > ~7,000 set add table statements for tables with primary keys
> > ~9,000 table add key/set add table statement pairs for tables without
> > primary keys
> >
> > So I have a 25,000 line slonik script (which includes a relatively
> > insignificant number of sequences, too).
> >
> > -tfo
>
> Ok I'm testing a solution now and so far so good, 6 hours into testing it's
> mannaged to add the 7,500 set add table statements for tables with primary
> keys and its 5300 of the way through the 9,500 table add key/set add table
> statement pairs for  tables without primary keys with out a catch so far.
>
> (Ohh how a long for a faster development system...)

Ok in a followup to the above information I can now say that with the 
following patch, everything works as it should.  It took over 24 hours for my 
hardware to create the db, init the cluster, and sync the empty schema.
Attached you will find references both the patch, and my test script.

the patch:		http://www.dbitech.ca/dbutil.patch
the testscript:	http://www.dbitech.ca/darcy.ik.gz

If you could please test the patch in your setup and see how it performs for 
you, and provide feedback on it.


>
> > _______________________________________________
> > Slony1-general mailing list
> > Slony1-general at gborg.postgresql.org
> > http://gborg.postgresql.org/mailman/listinfo/slony1-general

-- 
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx:  250.763.1759
http://www.wavefire.com