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