[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