Re: [PERFORM] Poor performance on an aggregate query

2013-04-15 Thread Peter Geoghegan
On Mon, Apr 15, 2013 at 1:59 PM, Anne Rosset wrote: > I have this simple query that has performance issue. I am assuming there is > something wrong in our configuration. Can someone point me to the right > direction? (our work_mem is set to 64MB) Why don't you try creating a functional index on

[PERFORM] Poor performance on an aggregate query

2013-04-15 Thread Anne Rosset
Hi all, I have this simple query that has performance issue. I am assuming there is something wrong in our configuration. Can someone point me to the right direction? (our work_mem is set to 64MB) srdb=> explain analyze 013-04-15 16:51:20,223 INFO [com.vasoftware.sf.server.common.querygenera