I wrote: > One more reason this point is an interesting one is that it is one > that gets *worse* with the suggested patch, if only by half a percent. > > Without: > > 600: 80: Medium Throughput: 82632.000 Avg Medium Resp: 0.005 > > with: > > 600: 80: Medium Throughput: 82241.000 Avg Medium Resp: 0.005 Oops. A later version: > Redid the test with - waking up all waiters irrespective of shared, > exclusive > 600: 80: Medium Throughput: 82920.000 Avg Medium Resp: 0.005 The one that showed the decreased performance at 800 was: > a modified Fix (not the original one that I proposed but something > that works like a heart valve : Opens and shuts to minimum > default way thus controlling how many waiters are waked up ) -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance