Dean Rasheed <dean.a.rasheed@gmail.com> writes:
> On 11 October 2010 18:48, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> And? �If the memory requirement actually fits, you're in good shape.
> Yeah but the actual memory requirement, if it uses a hash aggregate,
> is over 1GB, and could easily be much higher.
In that case the estimate of 30K per instance was wrong.
You still haven't explained why this is impossible to estimate,
or even particularly hard, as long as we can provide some code that
knows specifically about the behavior of this aggregate. The amount
of space needed to sort X amount of data is not unpredictable.
regards, tom lane