Re: SQL Tuning

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: SQL Tuning
Дата
Msg-id 200211111042.39796.dev@archonet.com
обсуждение исходный текст
Ответ на SQL Tuning  (Murali Mohan Kasetty <kasetty@india.hp.com>)
Список 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 по дате отправления:

Предыдущее
От: Lee Kindness
Дата:
Сообщение: Re: Column based on pg-general
Следующее
От: Helge Bahmann
Дата:
Сообщение: Re: Upgrade to dual processor machine?