Re: out of memory - Mailing list pgsql-performance

From martial.bizel@free.fr
Subject Re: out of memory
Date
Msg-id 1139933720.43f20218cfe3a@imp6-g19.free.fr
Whole thread Raw
In response to Re: out of memory  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: out of memory  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: out of memory  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
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
>



pgsql-performance by date:

Previous
From: Albert Cervera Areny
Date:
Subject: Re: copy and postgresql.conf
Next
From: "Jay Greenfield"
Date:
Subject: Re: Postgres slower than MS ACCESS