Re: Adding foreign key performance

Поиск
Список
Период
Сортировка
От John K. Herreshoff
Тема Re: Adding foreign key performance
Дата
Msg-id 200310281338.43414.jkherr@centurytel.net
обсуждение исходный текст
Ответ на Re: Adding foreign key performance  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Adding foreign key performance  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-performance
I'm not sure about the analyze stats...  Where would I find that  (in
postgresql.conf I suppose)  I'll go see what I have set up, and get back to
you in 30 minutes or less...

John.

On Tuesday 28 October 2003 13:34, Bruce Momjian wrote:
> John K. Herreshoff wrote:
> > 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...
>
> Did those tables have analyze statistics?  Can you try it without
> statistics (I think you have to drop the tables to erase the
> statistics).


В списке pgsql-performance по дате отправления:

Предыдущее
От: Jeff
Дата:
Сообщение: Re: Adding foreign key performance
Следующее
От: "Cestmir Hybl"
Дата:
Сообщение: Ignoring index on (A is null), (A is not null) conditions