Re: Indexing foreign keys

Поиск
Список
Период
Сортировка
От Ron St.Pierre
Тема Re: Indexing foreign keys
Дата
Msg-id 3E35C99B.5020105@syscor.com
обсуждение исходный текст
Ответ на Re: Indexing foreign keys  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Josh Berkus wrote:
> Matt,
>>Did the docs say to index those FK fields (is that standard in the DB
>>industry?), or was I just spoiled by IFX doing it for me?  ;)
> It's pretty standard in the DB industry.

I didn't know that, but I'm new to the DB field. I've gleaned quite a
few tips from this group, especially from responses to people with slow
queries/databases, but this is the first I've noticed it this tip. I'll
try it on my db too.


--
Ron St.Pierre
Syscor R&D
tel: 250-361-1681
email: rstpierre@syscor.com


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Indexing foreign keys
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: 7.3.1 New install, large queries are slow