From: Mark Lewis <mark.lewis@mir3.com>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: Karen Hill <karen_hill22@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How long should it take to insert 200,000 records?
Date: Tue, 06 Feb 2007 11:10:53 -0800
Message-ID: <1170789053.16656.486.camel@archimedes> (raw)
In-Reply-To: <b42b73150702061106r7ed1d643k84e44f051dd68aaa@mail.gmail.com>
References: <1170722158.973141.208230@j27g2000cwj.googlegroups.com>
<1170778484.5451.97.camel@state.g2switchworks.com>
<b42b73150702060840y5594ca57mace48fdbdb21fb78@mail.gmail.com>
<1170780953.5451.99.camel@state.g2switchworks.com>
<b42b73150702060901n7291a644xe496ed93962ed9f6@mail.gmail.com>
<1170786686.16656.484.camel@archimedes>
<b42b73150702061106r7ed1d643k84e44f051dd68aaa@mail.gmail.com>
On Tue, 2007-02-06 at 14:06 -0500, Merlin Moncure wrote:
> On 2/6/07, Mark Lewis <mark.lewis@mir3.com> wrote:
> > > actually, I get the stupid award also because RI check to unindexed
> > > column is not possible :) (this haunts deletes, not inserts).
> >
> > Sure it's possible:
> >
> > CREATE TABLE parent (col1 int4);
> > -- insert many millions of rows into parent
> > CREATE TABLE child (col1 int4 REFERENCES parent(col1));
> > -- insert many millions of rows into child, very very slowly.
>
> the database will not allow you to create a RI link out unless the
> parent table has a primary key/unique constraint, which the database
> backs with an index....and you can't even trick it afterwards by
> dropping the constraint.
>
> it's the other direction, when you cascade forwards when you can have
> a problem. this is most common with a delete, but can also happen on
> an update of a table's primary key with child tables referencing it.
>
Hmmm, should check my SQL before hitting send I guess. Well, at least
you no longer have to wear the stupid award, Merlin :)
-- Mark Lewis
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: mark.lewis@mir3.com, mmoncure@gmail.com, smarlowe@g2switchworks.com, karen_hill22@yahoo.com
Subject: Re: How long should it take to insert 200,000 records?
In-Reply-To: <1170789053.16656.486.camel@archimedes>
* 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