From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Sue Fitt <sue@inf.ed.ac.uk>
Cc: pgsql-performance@postgresql.org
Subject: Re: setting up foreign keys
Date: Thu, 10 Aug 2006 11:32:25 -0700 (PDT)
Message-ID: <20060810113004.K52796@megazone.bigpanda.com> (raw)
In-Reply-To: <44DAE8CF.1030107@inf.ed.ac.uk>
References: <44DAE8CF.1030107@inf.ed.ac.uk>
On Thu, 10 Aug 2006, Sue Fitt wrote:
> Hi all,
>
> This is my first post to the performance list, I hope someone can help me.
>
> I'm setting up a table with 2 columns, both of which reference a column
> in another table:
>
> CREATE TABLE headwords_core_lexemes (
> core_id int REFERENCES headwords_core(core_id),
> lexeme_id int REFERENCES headwords_core(core_id),
> );
>
> Trouble is, it's taken 18 hours and counting!
What precisely is taking the time, the create table itself? The only thing
that the create should be waiting for as far as I know is a lock on
headwords_core to add the triggers.
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: sszabo@megazone.bigpanda.com, sue@inf.ed.ac.uk
Subject: Re: setting up foreign keys
In-Reply-To: <20060810113004.K52796@megazone.bigpanda.com>
* 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