From: 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 10:02:43 -0500
Message-ID: <20040813150243.GA2004@wolff.to> (raw)
In-Reply-To: <1092401876.16087.236.camel@jester>
References: <20040813111649.7B4116C4F8@tino.sinectis.com.ar>
<00cc01c4812b$4e7f02e0$0100000a@wp2000>
<411CAFA3.90005@relevanttraffic.se>
<1092401876.16087.236.camel@jester>
On Fri, Aug 13, 2004 at 08:57:56 -0400,
Rod Taylor <pg@rbt.ca> wrote:
> On Fri, 2004-08-13 at 08:10, Ulrich Wisser wrote:
> > Hi,
> >
> > my inserts are done in one transaction, but due to some foreign key
> > constraints and five indexes sometimes the 100 inserts will take more
> > than 5 minutes.
>
> 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 the type mismatch
suggestion is probably what the problem is.
The current solution is to make the types match. In 8.0.0 it would probably
work efficiently as is, though it isn't normal for foreign keys to have a type
mismatch and he may want to change that anyway.
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: bruno@wolff.to, pg@rbt.ca, ulrich.wisser@relevanttraffic.se, gnari@simnet.is
Subject: Re: insert
In-Reply-To: <20040813150243.GA2004@wolff.to>
* 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