Re: Sort question ! ! !

Поиск
Список
Период
Сортировка
От Daniel T. Staal
Тема Re: Sort question ! ! !
Дата
Msg-id 61350.63.172.115.138.1165502227.squirrel@MageHandbook.com
обсуждение исходный текст
Ответ на Sort question ! ! !  (jennifer llerena <jenniferllerena@yahoo.com>)
Список pgsql-novice
On Thu, December 7, 2006 9:14 am, jennifer llerena said:
> hi everyone!
>
> I want to know if the sort process can be improve.
> Or what parameters should I check if it`s working with
> the best performance possible.
>
> thanks a lot!
>
> Jennifer Llerena

Run an 'Explain Analyze' on the queries you want to speed up, and see what
is taking the time.  Then you can look to see if reformulating the query
or putting in a new index may be helpful.

Daniel T. Staal

---------------------------------------------------------------
This email copyright the author.  Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes.  This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------


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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Sort question ! ! !
Следующее
От: "Lenorovitz, Joel"
Дата:
Сообщение: Help with Update Rule on View - 2nd Attempt