Re: How to use indexes for GROUP BY

Поиск
Список
Период
Сортировка
От Dimi Paun
Тема Re: How to use indexes for GROUP BY
Дата
Msg-id 1295931806.9380.1004.camel@dimi.lattica.com
обсуждение исходный текст
Ответ на Re: How to use indexes for GROUP BY  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance
On Mon, 2011-01-24 at 12:33 -0700, Scott Marlowe wrote:
> As another poster observed, you're running an ancient version of pgsql
> from a performance perspective.  Upgrading to 8.4 or 9.0 would make a
> huge difference in overall performance, not just with one or two
> queries.

Thanks for the trips.

I'll try to first upgrade, and I'll report back if that doesn't help :)

--
Dimi Paun <dimi@lattica.com>
Lattica, Inc.


В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Bloat issue on 8.3; autovac ignores HOT page splits?
Следующее
От: Cédric Villemain
Дата:
Сообщение: Re: Possible to improve query plan?