On Tue, 2006-02-14 at 10:03, martial.bizel@xxxxxxx 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.
