[Bucardo-general] speeding up bucardo.validate_sync

Greg Sabino Mullane greg at endpoint.com
Wed Jan 13 17:12:52 UTC 2016


On Tue, Jan 12, 2016 at 12:18:12PM -0800, Ben Chobot wrote:
> 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)

No particular reason, seems like a good change to make. Feel free 
to make a github pull request if you want to get in the habit, or 
I can just make it directly. 

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20160113/07897652/attachment.sig>


More information about the Bucardo-general mailing list