Thread: SQL Tuning

Hi All,

    Is there any tool available for tuning sql statements for
PostgreySQl.

Any pointers or help would be greatly appreciated.

Thanks in advance,
Murali

On Monday 11 Nov 2002 4:47 am, Murali Mohan Kasetty wrote:
> Hi All,
>
>     Is there any tool available for tuning sql statements for
> PostgreySQl.

There's nothing that will automatically tune them for you, but the standard
tool for profiling a query is EXPLAIN.

See the manuals for details on its use. I'd start with a simple query and
build up to more complex ones. Also check the list archives - plenty of
people have posted examples to the lists.
--
  Richard Huxton

Is PostgreySQL automatically instaleed?,When I install application soft
whichi need PostgreySQL.

Hi Turuki,

turuki wrote:
>
> Is PostgreySQL automatically instaleed?,When I install application soft
> whichi need PostgreySQL.

Which Operating System?

For example, Linux (Redhat, Debian, ... ), FreeBSD, Solaris, Windows,
etc?


And which application?

:)

+ Justin Clift

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi

On Mon, 11 Nov 2002, Murali Mohan Kasetty wrote:

> Hi All,
>
>     Is there any tool available for tuning sql statements for
> PostgreySQl.
>
> Any pointers or help would be greatly appreciated.

The most important tool for tuning SQL queries is your mind.  :-)

the next most important tool is the documentation.  Take a look here:

http://developer.postgresql.org/docs/postgres/performance-tips.html

And the other important tool are the 'explain' and 'explain analyze'
commands.