PostgreSQL - Giant Robots Smashing Into Other Giant Robots

- All Topics
- Design
- Development
- Product
- More topics
Advanced Postgres Performance Tips

What do you do when indexes aren’t enough?
Caleb Hearth
July 29, 2016
- PostgreSQL
- Databases
- SQL
- Performance
Reading a Postgres EXPLAIN ANALYZE Query Plan

Take a guided tour through a query plan for a “simple” SQL query.
Caleb Hearth
July 26, 2016
- PostgreSQL
- Databases
- SQL
- Performance
Postgres Index Types

Improve query performance by using the right index type.
Calle Erlandsson
April 21, 2016
- PostgreSQL
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
January 11, 2016
- PostgreSQL
- Rails
- Web
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
June 25, 2015
- Web
- Rails
- PostgreSQL
Have Some (Referential) Integrity with Foreign Keys

What is referential integrity and why is it important to your Rails apps?
Derek Prior
December 2, 2014
- Web
- Rails
- PostgreSQL
Postgres Window Functions

Take your queries to the next level with window functions.
Simon Taranto
September 16, 2014
- Web
- Performance
- PostgreSQL
- SQL
Why Postgres Won't Always Use an Index

Use SQL EXPLAIN to understand when and why indexes are used (or not).
Simon Taranto
July 25, 2014
- Web
- Performance
- PostgreSQL
- SQL
An Explained psqlrc

Let’s walk through my short psqlrc(5) to see what I’ve set, and to inspire...
Mike Burns
July 24, 2014
- Web
- PostgreSQL
Avoid the Three-state Boolean Problem

Use null: false, default: false on boolean columns in ActiveRecord migrations to avoid NULL problems.
Gabe Berke-Williams
February 24, 2014
- Web
- PostgreSQL
Sign up to receive a weekly recap from thoughtbot

Your email address

Looking for even more ways to stay connected?

Check out our feeds

Sign up to receive a weekly recap from thoughtbot