Saranya,
1) Please format the query you want help optimising. Proper query format
is like:
SELECT columns
FROM table JOIN table
JOIN table
WHERE condition
condition
LIMIT
2) Please run EXPLAIN ANALYZE rather than just EXPLAIN, and please run it
on the query you actually want help with (the query you gave us and the
explain output do not match).
3) Please give us the following settings from your PostgreSQL.conf:
effective_cache_size
random_page_cost
After that, we'll probably be able to help you!
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco