On Sat, Jan 6, 2018 at 12:30 PM, Melvin Davidson <melvin6925@xxxxxxxxx> 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."
