PostgreSQL: Foreign keys and insertion order in SQL
Foreign keys will introduce some issues which have to be considered when writing applications. If a foreign key is in place the inseration order starts to matter.
1-to-1 relationship in PostgreSQL for real
How to implement 1-to-1 relationship in PostgreSQL? Tricks with UNIQUE constraints? Check how to achive that using DEFERRABLE foreign keys.
Foreign Key Indexing and Performance in PostgreSQL
by
Laurenz Albe |
10.2018Foreign key constraints are an important tool to keep your database consistent while also documenting relationships between tables. A fact […]
PostgreSQL: Indexes and foreign keys
Missing indexes and foreign keys may cause database performance problems. Learn how to speed up things dramatically - not only in PostgreSQL!
