Re: array_accum aggregate

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: array_accum aggregate
Дата
Msg-id 20061006220650.GL24675@kenobi.snowman.net
обсуждение исходный текст
Ответ на array_accum aggregate  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
* Stephen Frost (sfrost@snowman.net) wrote:
>   For comparison, the new functions run with:
>   time psql -c "select aaccum(generate_series) from generate_series(1,1000000);" > /dev/null
>       4.24s real     0.34s user     0.06s system
>
>   Compared to:
>   time psql -c "select array_accum(generate_series) from generate_series(1,1000000);" > /dev/null
>   ...
>
>   Well, it's still running and it's been over an hour.

Just to follow-up on this, the result was:
7601.36s real     0.36s user     0.02s system

Or about 2 hours.
    Enjoy,
    Stephen

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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: array_accum aggregate
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: pg_upgrade: downgradebility