Re: Benchmarking Function

Поиск
Список
Период
Сортировка
От David Wheeler
Тема Re: Benchmarking Function
Дата
Msg-id E6E6A4F5-1A54-41D2-B6C3-9E9BDBDB8D13@kineticode.com
обсуждение исходный текст
Ответ на Re: Benchmarking Function  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
On May 21, 2006, at 12:23, Josh Berkus wrote:

> Well, per our conversation the approach doesn't really work.   EXECUTE
> 'string' + generate_series seems to carry a substantial and
> somewhat random
> overhead, between 100ms and 200ms -- enough to wipe out any
> differences
> between queries.

Per our conversation I eliminated the EXECUTE 'string' +
generate_series. Check it out.

   http://theory.kineticode.com/computers/databases/postgresql/
benchmarking_functions.html

(Temporary URL; justatheory.com seems to have disappeared from DNS...

Best,

David

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

Предыдущее
От: Brendan Duddridge
Дата:
Сообщение: Re: Performs WAY better with enable_seqscan = off
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: utilizing multiple disks for i/o performance