On Fri, 2010-04-23 at 11:32 -0400, Robert Haas wrote:
> > 99% of transactions happen in similar times between primary and standby,
> > everything dragged down by rare but severe spikes.
> > We're looking for something that would delay something that normally
> > takes <0.1ms into something that takes >100ms, yet does eventually
> > return. That looks like a severe resource contention issue.
> Wow. Good detective work.
While we haven't fully established the source of those problems, I am
now happy that these test results don't present any reason to avoid
commiting the main patch tested by Erik (not the smaller additional one
I sent). I expect to commit that on Sunday.
Simon Riggs www.2ndQuadrant.com
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2010-04-23 22:42:34|
|Subject: Re: recovery_connections cannot start (was Re: master in standby mode croaks) |
|Previous:||From: Tom Lane||Date: 2010-04-23 22:38:03|
|Subject: Re: Postgres stats collector showing high disk I/O |