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, [EMAIL PROTECTED] 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 > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
