Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group