Line 821 of Bucardo 4.5.1's validate_sync function reads:

DELETE FROM bucardo.bucardo_delta_targets
 WHERE tablename NOT IN (select oid from pg_class)

Is there some reason why this isn't the much more performant:

DELETE FROM bucardo.bucardo_delta_targets
 WHERE NOT EXISTS (select oid from pg_class where oid=tablename)

?

Especially when setting up a lot of tables to replicate, this can make orders 
of magnitude of difference.
_______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general

Reply via email to