Re: array_agg crash? - Mailing list pgsql-general

From Chris Spotts
Subject Re: array_agg crash?
Date
Msg-id 00ef01ca0a25$fa4f7720$eeee6560$@com
Whole thread Raw
In response to Re: array_agg crash?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: array_agg crash?
List pgsql-general
> >> How big were the arrays you were trying to push around here?
>
> > Like I'd said originally, there were no arrays that ended up being
> more 4
> > elements long -  all integers. The vast majority of them were 1 or 2
> long.
>
> Hm, maybe the problem is not so much array size as too many arrays.
> How
> many groups are you expecting in that query?  Does the plan for the
> array_agg query show hash or group aggregation?
>
>             regards, tom lane
[Spotts, Christopher]
GroupAggregate


pgsql-general by date:

Previous
From: Bjørn T Johansen
Date:
Subject: ERROR: could not access status of transaction 2495690984
Next
From: Tom Lane
Date:
Subject: Re: killing processes