On Thu, 1 Apr 2010, Eliot Gable wrote:
On Thu, Apr 1, 2010 at 3:01 PM, Faheem Mitha <faheem@xxxxxxxxxxxxx> wrote: So, should I add indexes on the individual foreign key cols idlink_id and anno_id after all? I doubt that would help. You're sure of this? It is always best to test and be certain.
Fair enough. I may also try disabling hash joins and see what happens... Regards, Faheem. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance