Re: reducing the overhead of frequent table locks - now, with WIP patch

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Jignesh Shah <jkshah(at)gmail(dot)com>
Subject: Re: reducing the overhead of frequent table locks - now, with WIP patch
Date: 2011-06-06 18:49:29
Message-ID: 4DED2139.8060408@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> That's an improvement of about ~3.5x. According to the vmstat output,
> when running without the patch, the CPU state was about 40% idle.
> With the patch, it dropped down to around 6%.

Wow! That's fantastic.

Jignesh, are you in a position to test any of Robert's work using DBT or
other benchmarks?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2011-06-06 19:12:54 Re: reducing the overhead of frequent table locks - now, with WIP patch
Previous Message Merlin Moncure 2011-06-06 18:42:06 Re: Error in PQsetvalue