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

Поиск
Список
Период
Сортировка
От Jignesh Shah
Тема Re: reducing the overhead of frequent table locks - now, with WIP patch
Дата
Msg-id BANLkTi=rQxgaqwKM1GLqmsGY08b5sMTwSg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: reducing the overhead of frequent table locks - now, with WIP patch  (Josh Berkus <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: reducing the overhead of frequent table locks - now, with WIP patch
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: reducing the overhead of frequent table locks - now, with WIP patch