Re: array_agg performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: array_agg performance
Дата
Msg-id 12606.1255148468@sss.pgh.pa.us
обсуждение исходный текст
Ответ на array_agg performance  ("Spotts, Christopher" <Christopher.Spotts@TransCore.com>)
Список pgsql-general
Дерево обсуждения 
"Spotts, Christopher" <Christopher.Spotts@TransCore.com> writes:
> Using postgres 8.4.1, I thought the upgrade from 8.4.0 would help with
> array_agg.

> Using ARRAY() with a subselect is yielding results hundreds times faster
> than array_agg even though its plan looks  much worse...

Huh, you sure your server is on 8.4.1?  I can't reproduce any memory
leak here (not that you've provided a self-contained example).

            regards, tom lane

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

Предыдущее
От: Robert Treat
Дата:
Сообщение: Volunteers needed to help staff the PostgreSQL Booth at LISA 2009
Следующее
От: Nick
Дата:
Сообщение: Access dynamic NEW.column_name in trigger?