Re: array_agg performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Spotts, Christopher" <Christopher(dot)Spotts(at)TransCore(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: array_agg performance
Date: 2009-10-10 04:21:08
Message-ID: 12606.1255148468@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Spotts, Christopher" <Christopher(dot)Spotts(at)TransCore(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Diehl 2009-10-10 06:54:47 Re: Stuck vacuum...
Previous Message Robert Treat 2009-10-10 04:01:50 Volunteers needed to help staff the PostgreSQL Booth at LISA 2009