Why You Should Add Indexes to Foreign Key Refs in PostgreSQL

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

Overview When building a data model for PostgreSQL, you're more than likely to have foreign keys to define relationships between tables. When you have those foreign keys, one quick way to optimize your queries and allow them to be significantly faster is to index on those foreign key references.

Read on rishigoomar.com ↗