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:21:37
Message-ID: 1139934097.22740.182.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 2006-02-14 at 10:15, martial(dot)bizel(at)free(dot)fr wrote:
> Yes, I've launched ANALYZE command before sending request.
> I precise that's postgres version is 7.3.4

So what does explain analyze show for this query, if anything? Can you
increase your sort_mem or shared_buffers (I forget which hash_agg uses
off the top of my head...) if necessary to make it work. Note you can
increase sort_mem on the fly for a given connection.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2006-02-14 16:23:09 Re: Postgres slower than MS ACCESS
Previous Message Jay Greenfield 2006-02-14 16:17:08 Re: Postgres slower than MS ACCESS