| From: | Jignesh Shah <jkshah(at)gmail(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: reducing the overhead of frequent table locks - now, with WIP patch |
| Date: | 2011-06-06 19:54:07 |
| Message-ID: | BANLkTi=rQxgaqwKM1GLqmsGY08b5sMTwSg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Jun 6, 2011 at 2:49 PM, Josh Berkus <josh(at)agliodbs(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Browne | 2011-06-06 19:59:47 | Re: reducing the overhead of frequent table locks - now, with WIP patch |
| Previous Message | Dave Page | 2011-06-06 19:52:43 | Re: reducing the overhead of frequent table locks - now, with WIP patch |