Re: Poor performance on an aggregate query

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Poor performance on an aggregate query
Дата
Msg-id CAEYLb_WcW=c-Yong3g6UEn=n+m4L=6waEk6DwPZi4jdD9uhFkA@mail.gmail.com
обсуждение исходный текст
Ответ на Poor performance on an aggregate query  (Anne Rosset <arosset@collab.net>)
Список pgsql-performance
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Anne Rosset
Дата:
Сообщение: Poor performance on an aggregate query
Следующее
От: Franck Routier
Дата:
Сообщение: Re: Postgresql performance degrading... how to diagnose the root cause