On Sun, Mar 27, 2011 at 6:07 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
> Simon Riggs wrote:
>
>> I'm surprised that a network roundtrip takes less time than the
>> backend takes to mark clog and then queue for the SyncRepLock.
>
> I'm not surprised by that at all. Some of our replication involves
> Gb or faster connections on the same LAN segment (sometimes on the
> same switch).
>
> That's rather beside the point though -- on a busy system a process
> can get starved long enough to make some seemingly improbably timings
> occur. PostgreSQL shouldn't fall over just because the load gets
> heavy enough to cause such timings. A race condition is a race
> condition.
That has been fixed, without discussion. The discussion was about ...,
well, something else.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services