Force PostgreSQL to use indexes on foreign key lookups - Was: Slow Inserts on 1 table?

[Dan Armbrust <daniel.armbrust.list@xxxxxxxxx>]

An aha moment:

http://archives.postgresql.org/pgsql-bugs/2005-03/msg00183.php

Some of the ensuing conversation seemed to indicate that a change was 
made in the 8.0 branch in March, that was intended to fix this issue.  
Any idea if that fix would have made it into the 8.0.3 release? 

Or maybe the fix didn't fix the issue.

Dan


--
****************************
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
http://informatics.mayo.edu/


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster