[Bucardo-general] Performance issues... (4.5.x)

[Greg Sabino Mullane]

On Mon, Apr 29, 2013 at 05:39:22PM +0200, Michelle Sullivan wrote:
...
> Removed replication triggers from the tables: commits take: 35 ms per URL
> 
> Added triggers, and ran "validate all", truncated tables used.. commit
> takes: 8-10s per URL

Certainly sounds like a locking issue. There is no way the writes themselves 
to bucardo_delta are taking that long. Can you check pg_locks during that 
8-10s wait and determine anything of interest, e.g. locks not granted and 
waiting?


-- 
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: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130429/c33cc13b/attachment.sig>