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]