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

Поиск
Список
Период
Сортировка
От Noah Misch
Тема Re: reducing the overhead of frequent table locks - now, with WIP patch
Дата
Msg-id 20110603181003.GA1222@tornado.leadboat.com
обсуждение исходный текст
Ответ на reducing the overhead of frequent table locks - now, with WIP patch  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Fri, Jun 03, 2011 at 09:17:08AM -0400, Robert Haas wrote:
> As you can see, this works out to a bit more than a 4% improvement on
> this two-core box.  I also got access (thanks to Nate Boley) to a
> 24-core box and ran the same test with scale factor 100 and
> shared_buffers=8GB.  Here are the results of alternating runs without
> and with the patch on that machine:
> 
> tps = 36291.996228 (including connections establishing)
> tps = 129242.054578 (including connections establishing)
> tps = 36704.393055 (including connections establishing)
> tps = 128998.648106 (including connections establishing)
> tps = 36531.208898 (including connections establishing)
> tps = 131341.367344 (including connections establishing)

Nice!


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Domains versus polymorphic functions, redux
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Streaming solution and v3.1 protocol