Horton
Menu

Re: spinlock->pthread_mutex : first results with Jeff's pgbench+plsql

Nils Goroll <slink@schokola.de>

View thread
From: Nils Goroll <slink@schokola.de>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Jeff Janes <jeff.janes@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, Martijn van Oosterhout <kleptog@svana.org>, Merlin Moncure <mmoncure@gmail.com>, pgsql-hackers@postgresql.org
Date: 2012-07-02T15:38:08Z
Lists: pgsql-hackers 
> 3.1.7?

Sorry, that was a typo. 9.1.3.

Yes, I had mentioned the Version in my initial posting. This version is the one
I need to work on as long as 9.2 is beta.

> A major scalability bottleneck caused by spinlock contention was fixed
> in 9.2 - see commit b4fbe392f8ff6ff1a66b488eb7197eef9e1770a4.  I'm not
> sure that it's very meaningful to do performance testing on versions
> that are known to be out of date.

Apparently I have not pointed this out clearly enough. Sorry.

Nils

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Reduce sinval synchronization overhead.