Re: insert

From: "Matt Clark" <matt(at)ymogen(dot)net>
To: "'Bruno Wolff III'" <bruno(at)wolff(dot)to>, "'Rod Taylor'" <pg(at)rbt(dot)ca>
Cc: "'Ulrich Wisser'" <ulrich(dot)wisser(at)relevanttraffic(dot)se>, "'gnari'" <gnari(at)simnet(dot)is>, "'Postgresql Performance'" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: insert
Date: 2004-08-13 16:17:10
Message-ID: 006901c48150$fcfafb10$8300a8c0@solent
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> > It is likely that you are missing an index on one of those foreign
> > key'd items.
>
> I don't think that is too likely as a foreign key reference
> must be a unique key which would have an index.

I think you must be thinking of primary keys, not foreign keys. All
one-to-many relationships have non-unique foreign keys.

In response to

  • Re: insert at 2004-08-13 15:02:43 from Bruno Wolff III

Responses

  • Re: insert at 2004-08-13 16:31:34 from Bruno Wolff III

Browse pgsql-performance by date

  From Date Subject
Next Message Bruno Wolff III 2004-08-13 16:31:34 Re: insert
Previous Message Pierre-Frédéric Caillaud 2004-08-13 16:12:34 Reiser4