Re: What is the best way to optimize the query.

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: Srikanth <srikanth(at)inventum(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: What is the best way to optimize the query.
Date: 2010-07-19 06:07:26
Message-ID: AANLkTinFQ8BqKzrQtUpMnrQt4E7n2f1fzLZxKh8jyliO@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello,

On 17 July 2010 12:50, Srikanth <srikanth(at)inventum(dot)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(dot)ru(at)gmail(dot)com / Skype: gray-hemp / ICQ: 29353802

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2010-07-19 06:08:43 Re: What is the best way to optimize the query.
Previous Message Tatsuo Ishii 2010-07-19 02:50:34 Re: Pooling in Core WAS: Need help in performance tuning.