On Tue, 2006-02-14 at 10:15, [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
