[Bucardo-general] Swap replication latency
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
Atlanta, GA 30303
More information about the Bucardo-general