PostgreSQL Deep Dive

PostgreSQL Deep Dive covers: Essential PostgreSQL, Learn PostgreSQL, Learning PostgreSQL 10. Master PostgreSQL specifically — not just SQL, but psql, system catalogs, pg_stat views, configuration tuning, extensions, and the PostgreSQL-specific features that make it the best database for Rails applications. Go from "I use PostgreSQL" to "I understand PostgreSQL." Rails migrations create tables, but understanding pg_stat_statements, vacuum, bloat, and lock contention is what separates senior from staff. When you run rails db:migrate and add a column, do you know that ALTER TABLE ADD COLUMN with a default value used to rewrite the entire table in PostgreSQL < 11 but is now instant? When you add an index, do you know that CREATE INDEX locks the table for writes, but CREATE INDEX CONCURRENTLY does not (and that strong_migrations gem enforces this)? When your Rails app has 100 Puma threads and 50 Sidekiq threads, do you know that you need at least 150 database connections (and that PgBouncer in transaction mode can reduce that to 20 actual PostgreSQL connections)?