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 ?

-- 
Hannu Krosing <hannu at skype.net>