"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