Yes, I've launched ANALYZE command before sending request.
I precise that's postgres version is 7.3.4
> On Tue, 2006-02-14 at 10:03, martial.bizel@free.fr wrote:
> > Thanks for your response,
>
> SNIP
>
> > if HashAgg operation ran out of memory, what can i do ?
>
> 1: Don't top post.
>
> 2: Have you run analyze? Normally when hash agg runs out of memory, the
> planner THOUGHT the hash agg would fit in memory, but it was larger than
> expected. This is commonly a problem when you haven't run analyze.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>