On Sat, Mar 27, 2010 at 6:06 AM, <tomas@tuxteam.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@postgresql.org. 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