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

From: Dan Armbrust <daniel(dot)armbrust(dot)list(at)gmail(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Force PostgreSQL to use indexes on foreign key lookups - Was: Slow Inserts on 1 table?
Date: 2005-08-02 16:05:48
Message-ID: 42EF99DC.7040304@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-08-02 16:08:18 Re: CLUSTER equivalent
Previous Message Scott Marlowe 2005-08-02 15:57:11 Re: feeding big script to psql