Re: Ideas to deal with table corruption
| От | Corey Taylor |
|---|---|
| Тема | Re: Ideas to deal with table corruption |
| Дата | |
| Msg-id | CADBz387cdv6JgKt7PqJa=6Lf7dVepq+DMpi5=m_tijJHS=RNmA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Ideas to deal with table corruption (Melvin Davidson <melvin6925@gmail.com>) |
| Ответы |
Re: Ideas to deal with table corruption
Re: Ideas to deal with table corruption Re: Ideas to deal with table corruption Re: Ideas to deal with table corruption |
| Список | pgsql-admin |
On Sat, Jan 6, 2018 at 12:30 PM, Melvin Davidson <melvin6925@gmail.com> wrote:
Don't forget to create indexes on the FK's in the table they reference!Also, it would be nice to know the PostgreSQL version and O/S.
Is it possible for an index to not exist on those columns?
"A foreign key must reference columns that either are a primary key or form a unique constraint. This means that the referenced columns always have an index (the one underlying the primary key or unique constraint); so checks on whether a referencing row has a match will be efficient."
В списке pgsql-admin по дате отправления: