Re: BUG #5392: Query Optimization

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: tomas(at)tuxteam(dot)de
Cc: sachin <sachin(dot)desire(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5392: Query Optimization
Date: 2010-03-29 00:17:54
Message-ID: 603c8f071003281717u6a1de915q7dbc9e582bd209b3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2010-03-29 00:20:17 Re: BUG #5389: Column order on dump/reload broken from defined setof function
Previous Message Tom Lane 2010-03-28 20:01:57 Re: BUG #5394: invalid __declspec for PG_MODULE_MAGIC