Postgres Pro
Downloads
Home   >   mailing lists

Re: array_agg performance - Mailing list pgsql-general

From Tom Lane
Subject Re: array_agg performance
Date
Msg-id 12606.1255148468@sss.pgh.pa.us
Whole thread Raw
In response to array_agg performance  ("Spotts, Christopher" <Christopher.Spotts@TransCore.com>)
List pgsql-general
Tree view 
"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 by date:

Previous
From: Robert Treat
Date:
Subject: Volunteers needed to help staff the PostgreSQL Booth at LISA 2009
Next
From: Nick
Date:
Subject: Access dynamic NEW.column_name in trigger?