[Bucardo-general] Swap replication latency

Alex Balashov abalashov at evaristesys.com
Mon May 2 04:22:50 UTC 2011

On 05/02/2011 12:19 AM, David Christensen wrote:
> 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?


Alex Balashov - Principal
Evariste Systems LLC
260 Peachtree Street NW
Suite 2200
Atlanta, GA 30303
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/

More information about the Bucardo-general mailing list