Re: Adding foreign key performance

Поиск
Список
Период
Сортировка
От John K. Herreshoff
Тема Re: Adding foreign key performance
Дата
Msg-id 200310281306.10779.jkherr@centurytel.net
обсуждение исходный текст
Ответ на Re: Adding foreign key performance  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Ответы Re: Adding foreign key performance  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: markw@osdl.org
Дата:
Сообщение: Re: analyzing postgresql performance for dbt-2
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Adding foreign key performance