Re: reducing the overhead of frequent table locks - now, with WIP patch - Mailing list pgsql-hackers

From Jignesh Shah
Subject Re: reducing the overhead of frequent table locks - now, with WIP patch
Date
Msg-id BANLkTi=rQxgaqwKM1GLqmsGY08b5sMTwSg@mail.gmail.com
Whole thread Raw
In response to Re: reducing the overhead of frequent table locks - now, with WIP patch  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On Mon, Jun 6, 2011 at 2:49 PM, Josh Berkus <josh@agliodbs.com> wrote:
>
>> 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
>


I missed the discussion. Can you send me the patch (will that work
with 9.1 beta?)? I can do a before and after with DBT2 and let you
know.
And also test it with sysbench read test  which also has a relation
locking bottleneck.

Thanks.

Regards,
Jignesh


pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: reducing the overhead of frequent table locks - now, with WIP patch
Next
From: Christopher Browne
Date:
Subject: Re: reducing the overhead of frequent table locks - now, with WIP patch