Re: Query performance

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Query performance
Дата
Msg-id 1088605644.12340.10.camel@jester
обсуждение исходный текст
Ответ на Re: Query performance  ("Bill" <bill@math.uchicago.edu>)
Список pgsql-performance
> Can I get any better performance?

You can try bumping your sort memory way up (for this query only).

Another method would be to cluster the table by the symbol column
(eliminates the expensive sort).

If you could run a very simple calculation against open & close numbers
to eliminate a majority of symbols early, that would be useful as well.



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

Предыдущее
От: "Bill"
Дата:
Сообщение: Re: Query performance
Следующее
От: Litao Wu
Дата:
Сообщение: Re: reindex and copy - deadlock?