Take a guided tour through a query plan for a “simple” SQL query.
Improve query performance by using the right index type.
Database views can improve the performance, composability, and readability of
your rails application and Scenic is here to help.
Improve the speed of Postgres full-text search by introducing a tsvector column to cache lexemes and using a trigger to keep the lexemes up-to-date.
What is referential integrity and why is it important to your Rails apps?
Take your queries to the next level with window functions.
Use SQL EXPLAIN to understand when and why indexes are used (or not).
Let’s walk through my short psqlrc(5) to see what I’ve set, and to inspire...
Use null: false, default: false on boolean columns in
ActiveRecord migrations to avoid NULL problems.
Understanding the ~/.psqlrc configuration file, its options, and
reading...