Ken Geis <[EMAIL PROTECTED]> writes:
>  From what I've learned, we want to convince the optimizer to use a 
> table scan; that's a good thing.  I want it to use hashed aggregates, 
> but I can't convince it to (unless maybe I removed all of the 
> statistics.)

You probably just need to increase sort_mem.  Multiple aggregates take
more RAM to process in a hashtable style ...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to