> -----Original Message----- > From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] > Sent: Tuesday, July 21, 2009 12:16 PM > To: Chris Spotts > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: array_agg crash? > > "Chris Spotts" <rfusca@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general