From: Tom Lane <tgl@sss.pgh.pa.us>
To: Scott Marlowe <smarlowe@qwest.net>
Cc: Mauri Sahlberg <Mauri.Sahlberg@claymountain.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [Fwd: Re: RHDB just sits and does nothing?]
Date: Wed, 09 Jun 2004 09:46:41 -0400
Message-ID: <20391.1086788801@sss.pgh.pa.us> (raw)
In-Reply-To: <1086786111.23855.4.camel@localhost.localdomain>
References: <63280.195.197.242.66.1086768991.squirrel@www.claymountain.com>
<1086786111.23855.4.camel@localhost.localdomain>
"Scott Marlowe" <smarlowe@qwest.net> writes:
> On Wed, 2004-06-09 at 02:16, Mauri Sahlberg wrote:
>> It just took about three quarters of a hour to delete 6500 rows!
> Do you have any foreign key references that are of mismatched types
> involved?
Specifically, what other tables reference this one? Are their
referencing columns of identical types, and *do they have indexes*?
I'm betting on lack of index myself; that's the only FK mistake that
hurts you only at primary-key-delete time.
regards, tom lane
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, smarlowe@qwest.net, Mauri.Sahlberg@claymountain.com
Subject: Re: [Fwd: Re: RHDB just sits and does nothing?]
In-Reply-To: <20391.1086788801@sss.pgh.pa.us>
* 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