Postgres Pro
Downloads
Home   >   mailing lists

Re: Poor performance on an aggregate query - Mailing list pgsql-performance

From Peter Geoghegan
Subject Re: Poor performance on an aggregate query
Date
Msg-id CAEYLb_WcW=c-Yong3g6UEn=n+m4L=6waEk6DwPZi4jdD9uhFkA@mail.gmail.com
Whole thread Raw
In response to Poor performance on an aggregate query  (Anne Rosset <arosset@collab.net>)
List pgsql-performance
Tree view 
On Mon, Apr 15, 2013 at 1:59 PM, Anne Rosset <arosset@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

pgsql-performance by date:

Previous
From: Anne Rosset
Date:
Subject: Poor performance on an aggregate query
Next
From: Franck Routier
Date:
Subject: Re: Postgresql performance degrading... how to diagnose the root cause