On Sat, Jan 6, 2018 at 12:30 PM, Melvin Davidson <melvin6...@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? https://www.postgresql.org/docs/current/static/ddl-constraints.html#DDL-CONSTRAINTS-FK "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."
