Re: Ideas to deal with table corruption - Mailing list pgsql-admin

From Corey Taylor
Subject Re: Ideas to deal with table corruption
Date
Msg-id CADBz387cdv6JgKt7PqJa=6Lf7dVepq+DMpi5=m_tijJHS=RNmA@mail.gmail.com
Whole thread Raw
In response to Re: Ideas to deal with table corruption  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: Ideas to deal with table corruption  (scott ribe <scott_ribe@elevated-dev.com>)
Re: Ideas to deal with table corruption  (scott ribe <scott_ribe@elevated-dev.com>)
Re: Ideas to deal with table corruption  (Rui DeSousa <rui.desousa@icloud.com>)
Re: Ideas to deal with table corruption  (Rui DeSousa <rui.desousa@icloud.com>)
List 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 by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Ideas to deal with table corruption
Next
From: scott ribe
Date:
Subject: Re: Ideas to deal with table corruption