"Carlo Stonebanks" <stonec.register@xxxxxxxxxxxx> 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