"Ram Ravichandran" <ramkaka(at)gmail(dot)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