Re: out of memory

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: martial(dot)bizel(at)free(dot)fr
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: out of memory
Date: 2006-02-14 16:06:41
Message-ID: 1139933201.22740.179.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 2006-02-14 at 10:03, martial(dot)bizel(at)free(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Albert Cervera Areny 2006-02-14 16:06:59 Re: copy and postgresql.conf
Previous Message Scott Marlowe 2006-02-14 16:04:45 Re: Postgres slower than MS ACCESS