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

From John K. Herreshoff
Subject Re: Adding foreign key performance
Date
Msg-id 200310281306.10779.jkherr@centurytel.net
Whole thread Raw
In response to Re: Adding foreign key performance  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: Adding foreign key performance  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-performance
FWIW:  I'm fiddling with that right now, and the FK think was quick...  a few
seconds...  the tables in question have 1400 records, 343000 records and 7200
records...  I'm running Beta5...

John.

On Tuesday 28 October 2003 10:21, Stephan Szabo wrote:
> On Tue, 28 Oct 2003, Jeff wrote:
> > 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.
> >
> > Could it be this patch never made it in?
>
> I think it went in between b4 and b5, can you try with b5?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html


pgsql-performance by date:

Previous
From: markw@osdl.org
Date:
Subject: Re: analyzing postgresql performance for dbt-2
Next
From: Stephan Szabo
Date:
Subject: Re: Adding foreign key performance