Hi,
On 2014-10-11 07:26:57 +0530, Amit Kapila wrote:
> On Sat, Oct 11, 2014 at 7:00 AM, Andres Freund <andres@2ndquadrant.com>
> > And since
> > your general performance numbers are a fair bit lower than what I see
> > with, hopefully, the same code on the same machine...
>
> You have reported numbers at 1000 scale factor and mine were
> at 3000 scale factor, so I think the difference is expected.
The numbers for 3000 show pretty much the same:
SCALE 128 160 175
HEAD 352113 339005 336491
LW_SHARED 365874 347931 342528
Hm. I wonder if you're using pgbench without -M prepared? That'd about
explain the difference.
Greetings,
Andres Freund
-- Andres Freund http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services