Re: adding foreign key constraint locks up table - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: adding foreign key constraint locks up table
Date
Msg-id 4D19A3450200002500038C2C@gw.wicourts.gov
Whole thread Raw
In response to Re: adding foreign key constraint locks up table  (Gurjeet Singh <singh.gurjeet@gmail.com>)
Responses Re: adding foreign key constraint locks up table
List pgsql-performance
Gurjeet Singh <singh.gurjeet@gmail.com> wrote:

> how many rows does "bbb" have? And what are the data types of
> column aaa.idand bbb.topic_id?

For that matter, is there a unique index (directly or as the result
of a constraint) on the aaa.id column (by itself)?

-Kevin

pgsql-performance by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: adding foreign key constraint locks up table
Next
From: Lew
Date:
Subject: Re: adding foreign key constraint locks up table