On Mon, Apr 15, 2013 at 1:59 PM, Anne Rosset <aros...@collab.net> 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 length(discussion_post.id)? -- Regards, Peter Geoghegan -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
