Re: Adding foreign key performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: Adding foreign key performance
Date
Msg-id 22514.1067356292@sss.pgh.pa.us
Whole thread Raw
In response to Adding foreign key performance  (Jeff <threshar@torgo.978.org>)
List pgsql-performance
Jeff <threshar@torgo.978.org> writes:
> I recalled seeing a thread on -HACKERS about some major improvements to the speed of adding an FK to an existing
tablein 7.4. Naturally I was curious and decided to give it a whirl. My findings are not too good. In fact, they are
bad. 
> 7.4b4, 10k shared buff, 256mb effective cache: 485706ms

You are testing the wrong version.  beta5 has the ADD FOREIGN KEY improvement.

            regards, tom lane

pgsql-performance by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Adding foreign key performance
Next
From: Christopher Browne
Date:
Subject: Re: Optimizing Performance