Re: Adding foreign key performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff <threshar(at)torgo(dot)978(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Adding foreign key performance
Date: 2003-10-28 15:51:32
Message-ID: 22514.1067356292@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jeff <threshar(at)torgo(dot)978(dot)org> writes:
> I recalled seeing a thread on -HACKERS about some major improvements to the speed of adding an FK to an existing table in 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Browne 2003-10-28 15:59:37 Re: Optimizing Performance
Previous Message Stephan Szabo 2003-10-28 15:21:51 Re: Adding foreign key performance