Re: Finding foreign keys that are missing indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Finding foreign keys that are missing indexes
Дата
Msg-id 18295.1230511356@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Finding foreign keys that are missing indexes  (plu 12 <plutard12@hotmail.com>)
Список pgsql-general
plu 12 <plutard12@hotmail.com> writes:
> Technically, would we also need to worry about constraints that are a prefix of an index? e.g., that an index on (f1,
f2)would be usable for a constraint on (f1)? 

I guess you could, but it seems overly complicated for something that's
just meant to locate trouble spots.

            regards, tom lane

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

Предыдущее
От: plu 12
Дата:
Сообщение: Re: Finding foreign keys that are missing indexes
Следующее
От: "Grzegorz Jaśkiewicz"
Дата:
Сообщение: Re: having two database clusters?