1. Reading a Postgres EXPLAIN ANALYZE Query Plan

    Take a guided tour through a query plan for a “simple” SQL query.

    Caleb Hearth

  2. Postgres Index Types

    Improve query performance by using the right index type.

    Calle Erlandsson

  3. Announcing Scenic - Versioned Database Views for Rails

    Database views can improve the performance, composability, and readability of your rails application and Scenic is here to help.

    Derek Prior

  4. Optimizing Full Text Search with Postgres tsvector Columns and Triggers

    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.

    Dan Croak

  5. Have Some (Referential) Integrity with Foreign Keys

    What is referential integrity and why is it important to your Rails apps?

    Derek Prior

  6. Postgres Window Functions

    Take your queries to the next level with window functions.

    Simon Taranto

  7. Why Postgres Won't Always Use an Index

    Use SQL EXPLAIN to understand when and why indexes are used (or not).

    Simon Taranto

  8. An Explained psqlrc

    Let’s walk through my short psqlrc(5) to see what I’ve set, and to inspire...

    Mike Burns

  9. Avoid the Three-state Boolean Problem

    Use null: false, default: false on boolean columns in ActiveRecord migrations to avoid NULL problems.

    Gabe Berke-Williams

  10. Improving the Command-Line Postgres Experience

    Understanding the ~/.psqlrc configuration file, its options, and reading...

    Gabe Berke-Williams

Sign up to receive a weekly recap from Giant Robots