Puny to Powerful PostgreSQL Rails Apps
summary
Five concrete takeaways: safe migrations split schema change from backfill using strong_migrations and batched, nontransactional updates to avoid table locks; a 10M‑row example drops a 330ms seq scan to 0.1ms with a primary key index; connection pooling via PG Bouncer reduces need to scale DB instances; use pg_stat_statements with PG Hero to find hot queries; schedule vacuum/reindex with pg_cron or pg_repack and implement monthly range partitions plus read replicas to retire old location data.
AI-written summary · about
chapters (4)
- 0:00Start
- 15:47Query Investigation Process
- 16:30Improving Query Performance
- 23:45Implementation Challenges
related talks
34mBeyond CRUD: the PostgreSQL techniques your Rails app is missing.
26mBiggish Data With Rails and Postgresql
40mrails db:migrate:safely
46mHow we made PG Fitter, Happier, More Productive
39mPostgres & Rails 6 Multi-DB: Pitfalls, Patterns, Performance
51mScaling Postgres to the next level at OpenAI
31mUsing Databases to pull your applications weight
46mUse PostgreSQL, not Rails, to make Rails Faster!