Skip site navigation (1) Skip section navigation (2)

Re: out of memory

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: martial(dot)bizel(at)free(dot)fr
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: out of memory
Date: 2006-02-14 16:50:35
Message-ID: 1139935835.22740.188.camel@state.g2switchworks.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, 2006-02-14 at 10:32, martial(dot)bizel(at)free(dot)fr wrote:
> command explain analyze crash with the "out of memory" error
> 
> I precise that I've tried a lot of values from parameters shared_buffer and
> sort_mem
> 
> now, in config file, values are :
> sort_mem=32768
> and shared_buffer=30000

OK, on the command line, try increasing the sort_mem until hash_agg can
work.  With a 4 gig machine, you should be able to go as high as needed
here, I'd think.  Try as high as 500000 or so or more.  Then when
explain analyze works, compare the actual versus estimated number of
rows.

In response to

Responses

pgsql-performance by date

Next:From: FERREIRA, William (VALTECH)Date: 2006-02-14 17:05:09
Subject: Re: copy and postgresql.conf
Previous:From: Tomeh, HusamDate: 2006-02-14 16:45:08
Subject: 0ut of Memory Error during Vacuum Analyze

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group