Re: SQL Tuning - Mailing list pgsql-general

From Richard Huxton
Subject Re: SQL Tuning
Date
Msg-id 200211111042.39796.dev@archonet.com
Whole thread Raw
In response to SQL Tuning  (Murali Mohan Kasetty <kasetty@india.hp.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Lee Kindness
Date:
Subject: Re: Column based on pg-general
Next
From: Helge Bahmann
Date:
Subject: Re: Upgrade to dual processor machine?