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

Greg Sabino Mullane greg at endpoint.com
Wed May 1 03:09:23 UTC 2013

On Tue, Apr 30, 2013 at 07:49:11PM +0200, Michelle Sullivan wrote:
> I'm having trouble here... without bucardo (4.x) I get a 10x speed
> improvement...
> Please suggestions on queries and expectations...

With the triggers enabled, during the 10s delay, run:

SELECT relation::regclass, * FROM pg_locks where not granted;

Any rows that show up are strong clues for a locking issue.

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/20130430/b9348bb3/attachment.sig>

More information about the Bucardo-general mailing list