Re: out of memory

On Tue, 2006-02-14 at 10:15, martial.bizel@free.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.