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

[Michelle Sullivan]

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
improvement...

Please suggestions on queries and expectations...

-- 
Michelle Sullivan
http://www.mhix.org/