Just to clarify: if I expect to join two tables that I expect to benfit from 
indexed scans, I should create indexes on the joined columns on BOTH sides?

Carlo


"Tom Lane" <[EMAIL PROTECTED]> wrote in message 
news:[EMAIL PROTECTED]
> "Carlo Stonebanks" <[EMAIL PROTECTED]> writes:
>> I didn't create an index on facility_address.address_id because I 
>> expected
>> joins to go in the other direction (from facility_address to address).
>
> Well, that's your problem right there ...
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
> 



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to