Skip site navigation (1) Skip section navigation (2)

Re: Adding foreign key performance

From: "John K(dot) Herreshoff" <jkherr(at)centurytel(dot)net>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>,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 18:06:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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...


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?

In response to


pgsql-performance by date

Next:From: markwDate: 2003-10-28 18:08:33
Subject: Re: analyzing postgresql performance for dbt-2
Previous:From: Josh BerkusDate: 2003-10-28 17:36:02
Subject: Re: Guesses on what this NestLoop is for?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group