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.


-- 
Darcy Buskermolen
Wavefire Technologies Corp.

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