[Bucardo-general] Swap replication latency

David Christensen david at endpoint.com
Wed May 11 13:58:16 UTC 2011

On May 11, 2011, at 8:44 AM, Alex Balashov wrote:

> On 05/11/2011 09:41 AM, Alex Balashov wrote:
>> What I'm getting out of the log file by following the activity of a
>> particular KID, as you suggested, is that it's executing statements very
>> slowly for no apparent reason.  Note the timestamps:
> Note: I have benchmarked these statements.  They do not inherently run 
> slowly, with or without user-space triggers attached.  At most they'd 
> take a few milliseconds, if that.
> In the case of the UPDATE statements, the WHERE criteria are all 
> properly composite-indexed.

ISTR you had some user-defined triggers on these tables as well; what types of actions do these triggers perform?  Additionally, are there any rules at play?


David Christensen
End Point Corporation
david at endpoint.com

More information about the Bucardo-general mailing list