On Thursday 14 July 2005 15:55, Hannu Krosing wrote:
> On N, 2005-07-14 at 08:36 -0700, Darcy Buskermolen wrote:
> > Hello,
> >
> > I have implemented an experimental patch that avoids index maintainance
> > during the SUBSCRIBE SET phase of replication.  This work is based apon
> > theory and findings of Jan.   My initial testing shows that  subscribing
> > a large heavily hit pgbench (scalling factor of 100 with 50 concurrent
> > clients) database can subscribe set in the same amount of time as it
> > takes to pg_dump | psql.
> >
> > Those of you who are interested can find the patch for 1.1 and CVS HEAD
> > at http://www.dbitech.ca/slony/patches/subscription-perf-patch . I make
> > no firm claim that, at this time, this patch will act as intended for
> > everybody.  It would help us in getting this patch fully ironed out and
> > applied to the main tree, if those of you who do try this patch would
> > report your findings back to the list, wether it be yes it works or I got
> > an error.
>
> Would something similar also work for enabling real truncate on a table
> with FK-s pointing to it ?

Well it requires something a bit different but here is my initial work on it:

http://www.dbitech.ca/slony/patches/disable-fkey-checks-and-allow-truncate-patch

There a few more things I need to test with it, but a run of test_3_pgbench  
with this patch results in 100% equal DB's

Once again the same claim is attached, as is the request for comments.


-- 
Darcy Buskermolen
Wavefire Technologies Corp.

http://www.wavefire.com
ph: 250.717.0200
fx: 250.763.1759