Re: SQL Tuning

From: Richard Huxton <dev(at)archonet(dot)com>
To: Murali Mohan Kasetty <kasetty(at)india(dot)hp(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: SQL Tuning
Date: 2002-11-11 10:42:39
Message-ID: 200211111042.39796.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • SQL Tuning at 2002-11-11 04:47:37 from Murali Mohan Kasetty

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Helge Bahmann 2002-11-11 11:56:11 Re: Upgrade to dual processor machine?
Previous Message Lee Kindness 2002-11-11 09:17:38 Re: Column based on pg-general