On Mon, Apr 15, 2013 at 1:59 PM, Anne Rosset <arosset@xxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
