Re: Poor performance on an aggregate query

From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: Anne Rosset <arosset(at)collab(dot)net>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Poor performance on an aggregate query
Date: 2013-04-15 21:04:43
Message-ID: CAEYLb_WcW=c-Yong3g6UEn=n+m4L=6waEk6DwPZi4jdD9uhFkA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Apr 15, 2013 at 1:59 PM, Anne Rosset <arosset(at)collab(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Franck Routier 2013-04-16 09:16:39 Re: Postgresql performance degrading... how to diagnose the root cause
Previous Message Anne Rosset 2013-04-15 20:59:50 Poor performance on an aggregate query