On Sat, Mar 27, 2010 at 6:06 AM, <tomas(at)tuxteam(dot)de> wrote:
>> I am facing problem in optimizing my this query. can u please let me know
>> how can i optimize this query.
> this is most probably not a PostgreSQL bug. You are more likely to get
> help from pgsql-novice(at)postgresql(dot)org(dot) But to help others help you, you
> should at least show the structure of your tables and indices.
See also http://wiki.postgresql.org/wiki/SlowQueryQuestions
...Robert