Re: FUNC_MAX_ARGS benchmarks

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: FUNC_MAX_ARGS benchmarks
Дата
Msg-id 3D503ED4.3050608@joeconway.com
обсуждение исходный текст
Ответ на Re: FUNC_MAX_ARGS benchmarks  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Peter Eisentraut wrote:
> Joe Conway writes:
>>Here's the multi-user test summary. Very little difference. The details
>>of the OSDB output are attached.
>
> The fact that the OSDB benchmark has just about the least possible test
> coverage of identifier handling and you still get a 2% performance drop is
> something I'm concerned about.
>

Of course that's on the single user test only. In the multi-user test
the two are neck-and-neck. If you really want to be concerned, see the
attached. This lines up results from:

REL7_2_STABLE with NAMEDATALEN = 32 and FUNC_MAX_ARGS = 16
7.3devel      with NAMEDATALEN = 32 and FUNC_MAX_ARGS = 32
7.3devel      with NAMEDATALEN = 128 and FUNC_MAX_ARGS = 32

In the single-user test, REL7_2_STABLE is best by about 10%. But in the
multi-user test (10 users), *both* 7.3devel tests are about 3.5% faster
than 7.2.

Joe

Вложения

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: SQL99 CONVERT() function
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Open 7.3 items