Re: Performance Optimization for Dummies 2 - the SQL - Mailing list pgsql-performance

From Tom Lane
Subject Re: Performance Optimization for Dummies 2 - the SQL
Date
Msg-id 12239.1160054675@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance Optimization for Dummies 2 - the SQL  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
List pgsql-performance
"Carlo Stonebanks" <stonec.register@sympatico.ca> 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: UPDATE becomes mired / win32
Next
From: "Merlin Moncure"
Date:
Subject: Re: Performance Optimization for Dummies 2 - the SQL