Re: FUNC_MAX_ARGS benchmarks

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: FUNC_MAX_ARGS benchmarks
Дата
Msg-id 565.1028347540@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: FUNC_MAX_ARGS benchmarks  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I wasn't terribly concerned because this wasn't a 2% on normal workload
> test, it was a 2% bang on function calls as fast as you can test.

No, it was a 2% hit on rather slow functions with only one call made
per query issued by the client.  This is not much of a stress test.

A more impressive comparison would be

select 2+2+2+2+2+2+ ... (iterate 10000 times or so)

and see how much that slows down.
        regards, tom lane


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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: char/varchar truncation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Planned simplification of catalog index updates