Will PG use composite index to enforce foreign keys?

Поиск
Список
Период
Сортировка
От John Burger
Тема Will PG use composite index to enforce foreign keys?
Дата
Msg-id E38BF7A5-36E7-4DE8-A3A0-422F7DEA625B@mitre.org
обсуждение исходный текст
Ответы Re: Will PG use composite index to enforce foreign keys?
Список pgsql-general
Hi -

I know that the foreign key machinery will use an index on the
referring column if one exists.  My question is whether it will use a
composite index?  For instance:

create table allLemmaSenseMap (
   wordID     integer references allLemmas,
   senseID    integer references allSenses,
   primary key (wordID, senseID)
);

If I delete something from allLemmas, will the FK check use the PK
index above?  (I know I should at least have an index on senseID as
well, because of the other foreign key.)

As a secondary question, is there any way I could have answered this
myself, using analyze, the system catalogs, etc?  ANALYZE DELETE
doesn't seem to show the FK checking that must go on behind the scenes.

Thanks.

- John D. Burger
   MITRE



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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: HD is flooded by Error Log info
Следующее
От: "Usama Dar"
Дата:
Сообщение: Re: 1 cluster on several servers