Re: Sort question ! ! ! - Mailing list pgsql-novice

From Daniel T. Staal
Subject Re: Sort question ! ! !
Date
Msg-id 61350.63.172.115.138.1165502227.squirrel@MageHandbook.com
Whole thread Raw
In response to Sort question ! ! !  (jennifer llerena <jenniferllerena@yahoo.com>)
List 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 by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Sort question ! ! !
Next
From: "Lenorovitz, Joel"
Date:
Subject: Help with Update Rule on View - 2nd Attempt