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

Michelle Sullivan michelle at sorbs.net
Tue Apr 30 17:49:11 UTC 2013

Greg Sabino Mullane wrote:
> 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?
I'm having trouble here... without bucardo (4.x) I get a 10x speed

Please suggestions on queries and expectations...

Michelle Sullivan

More information about the Bucardo-general mailing list