Re: FWD: fastlock+lazyvzid patch performance - Mailing list pgsql-hackers

From Robert Haas
Subject Re: FWD: fastlock+lazyvzid patch performance
Date
Msg-id BANLkTik-2H=e6dQnK_zJEiyR374Ye8_OmQ@mail.gmail.com
Whole thread Raw
In response to FWD: fastlock+lazyvzid patch performance  (karavelov@mail.bg)
List pgsql-hackers
On Fri, Jun 24, 2011 at 3:31 PM,  <karavelov@mail.bg> wrote:
> I post this results because they somehow contradict with previous results
> posted on the list. In
> my case the patches does not only improve peak performance but also improve
> the performance
> under load - without patches the performance with 256 clients is 53% of the
> peak performance
> that is obtained with 8 clients, with patches the performance with 256
> client is 79% of the peak
> with 8 clients.

I think this is strongly related to core count.  The spinlock
contention problems don't become really bad until you get up above 32
CPUs... at least from what I can tell so far.

So I'm not surprised it was just a straight win on your machine... but
thanks for verifying.  It's helpful to have more data points.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: karavelov@mail.bg
Date:
Subject: FWD: fastlock+lazyvzid patch performance
Next
From: Robert Haas
Date:
Subject: Re: ALTER TABLE lock strength reduction patch is unsafe