Postgres Pro
Downloads
Home   >   mailing lists

Re: What is the best way to optimize the query. - Mailing list pgsql-performance

From Sergey Konoplev
Subject Re: What is the best way to optimize the query.
Date
Msg-id AANLkTinFQ8BqKzrQtUpMnrQt4E7n2f1fzLZxKh8jyliO@mail.gmail.com
Whole thread Raw
In response to What is the best way to optimize the query.  (Srikanth <srikanth@inventum.net>)
List pgsql-performance
Tree view 
Hello,

On 17 July 2010 12:50, Srikanth <srikanth@inventum.net> wrote:
> I am sending u the query along with execution plan. Please help
>

It would be better if you start with it:

http://www.postgresql.org/docs/8.4/interactive/indexes.html
http://www.mohawksoft.org/?q=node/56


--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp / ICQ: 29353802

pgsql-performance by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Pooling in Core WAS: Need help in performance tuning.
Next
From: Craig Ringer
Date:
Subject: Re: What is the best way to optimize the query.