[Bucardo-general] Swap replication latency

David Christensen david at endpoint.com
Mon May 2 04:19:46 UTC 2011

On May 1, 2011, at 10:52 PM, Alex Balashov wrote:

> On 05/01/2011 09:36 PM, Greg Sabino Mullane wrote:
>> You need to check your logs and follow a single KID process to see
>> where all the time is being taken.
> I've tried, but none of the operations I could infer were happening 
> from the log seem to profile as taking more than a trivial amount of 
> time on the main or secondary DB.  We're probably not the DB experts 
> we think we are, but we do grasp indexing, normalisation and query 
> planning pretty well.  We do have a few trigger cascades, but we run 
> very high-volume systems using this database at times (higher-volume 
> than the installation under discussion);  if any of the individual 
> queries were ever slow, we'd have a hard time not knowing that.
> Does it help to turn up log verbosity?  Any other suggestions?

What PostgreSQL versions are these running on?


David Christensen
End Point Corporation
david at endpoint.com

More information about the Bucardo-general mailing list