Jeff <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org