"Ram Ravichandran" <ramkaka@gmail.com> writes:
> My questions are regarding join optimization:
It's difficult to answer any of your questions without more information
than you've provided. Have you tried looking at EXPLAIN ANALYZE output
for your query?
regards, tom lane