> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Tuesday, July 21, 2009 12:16 PM
> To: Chris Spotts
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] array_agg crash?
>
> "Chris Spotts" <rfusca(at)gmail(dot)com> writes:
> >> many groups are you expecting in that query? Does the plan for the
> >> array_agg query show hash or group aggregation?
>
> > GroupAggregate
>
> Huh, there's no reason it should take much memory then. Maybe you've
> found a memory leak. Can you put together a self-contained test case?
>
> regards, tom lane
[Spotts, Christopher]
I'll try to put something together tonight and let you know tomorrow.