On Sat, Mar 27, 2010 at 6:06 AM, <to...@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-nov...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs