From: Matt Clark <matt@ymogen.net>
To: 'Bruno Wolff III' <bruno@wolff.to>
To: 'Rod Taylor' <pg@rbt.ca>
Cc: 'Ulrich Wisser' <ulrich.wisser@relevanttraffic.se>
Cc: 'gnari' <gnari@simnet.is>
Cc: 'Postgresql Performance' <pgsql-performance@postgresql.org>
Subject: Re: insert
Date: Fri, 13 Aug 2004 17:17:10 +0100
Message-ID: <006901c48150$fcfafb10$8300a8c0@solent> (raw)
In-Reply-To: <20040813150243.GA2004@wolff.to>
> > 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: matt@ymogen.net, bruno@wolff.to, pg@rbt.ca, ulrich.wisser@relevanttraffic.se, gnari@simnet.is
Subject: Re: insert
In-Reply-To: <006901c48150$fcfafb10$8300a8c0@solent>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox