On 2014-09-29 11:31:11 +0200, Andres Freund wrote:
> On 2014-09-29 11:13:43 +0200, Andres Freund wrote:
> > I doubt it'll be hard to construct a case where it'll show. My first try
> > of using a pgbench scale 100, -M prepared, -cj8 with a custom file with
> > 1 write and 5 read transaction yielded the following on my laptop:
>
> Hm. On second thought that testcase probably *decreased* the bad effects
> of this because pgbench's readonly statements only touch one table...
I've attached the file nonetheless, for posterities sake.
Note it has the scale hardcoded...
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services