Skip site navigation (1) Skip section navigation (2)

Re: Sort question ! ! !

From: "Daniel T(dot) Staal" <DStaal(at)usa(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Sort question ! ! !
Date: 2006-12-07 14:37:07
Message-ID: 61350.63.172.115.138.1165502227.squirrel@MageHandbook.com (view raw or flat)
Thread:
Lists: 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.
---------------------------------------------------------------


In response to

pgsql-novice by date

Next:From: Lenorovitz, JoelDate: 2006-12-07 19:44:55
Subject: Help with Update Rule on View - 2nd Attempt
Previous:From: A. KretschmerDate: 2006-12-07 14:24:16
Subject: Re: Sort question ! ! !

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group