On Thu, Apr 5, 2012 at 5:41 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> I'm also loathe to back patch. But its not very often we find a
> problem that causes all backends to wait behind a single I/O.
You have a point.
Meanwhile, here are the benchmark results you requested. I did half
hour runs with -l. Here are the 90th-100th percentile latencies,
without patch and then with patch.
90 1668 1620
91 1747 1690
92 1845 1785
93 1953 1907
94 2064 2035
95 2176 2160
96 2300 2291
97 2461 2451
98 2739 2710
99 3542 3495
100 12955473 19072385
Overall tps, first without and then with patch:
tps = 14546.644712 (including connections establishing)
tps = 14550.515173 (including connections establishing)
TPS graphs by second attached.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
