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

From Dan Armbrust
Subject Force PostgreSQL to use indexes on foreign key lookups - Was: Slow Inserts on 1 table?
Date
Msg-id 42EF99DC.7040304@gmail.com
Whole thread Raw
In response to Re: Slow Inserts on 1 table?  ("Jim C. Nasby" <decibel@decibel.org>)
List pgsql-general
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/


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: feeding big script to psql
Next
From: Tom Lane
Date:
Subject: Re: CLUSTER equivalent