Re: contrib idea
От | Zeugswetter Andreas SB SD |
---|---|
Тема | Re: contrib idea |
Дата | |
Msg-id | 46C15C39FEB2C44BA555E356FBCD6FA4212883@m0114.s-mxs.net обсуждение исходный текст |
Ответ на | contrib idea ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>) |
Ответы |
Re: contrib idea
Re: contrib idea |
Список | pgsql-hackers |
> > If you have a foreign key on a column, then whenever the primary key is > > modified, the following checks may occur: > > > > * Check to see if the child row exists (no action) > > * Delete the child row (cascade delete) > > * Update the child row (cascade update) > > > > All of which will benefit from an index... > > OK, then perhaps we should be creating an index automatically? Folks? The index is only useful where you actually have an on delete or on update clause. I don't think we want to conditionally create an index. That would bee too confusing. A contrib, to find "suggested" indexes seems fine. Andreas
В списке pgsql-hackers по дате отправления: