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.