Just Use Postgres.

on YouTube ↗43m

" summary

Argues for replacing many add-on stores with Postgres 9.4 by showing real results at Heroku: partitioned tables handling 300M records with median query times ~4ms, monthly rollups at ~1800ms, triggers that route inserts into child partitions, and cron-driven partition creation and drop. Demonstrations include jsonb schemaless storage with GIN indexes, NOTIFY/LISTEN for pub/sub, materialized views for cached rollups, foreign tables, recursive CTEs for social-graph traversal, range types, and row-level/serializable locks to prevent race conditions.

AI-written summary · about

" chapters (13)

1. 0:00Intro
2. 0:50Just use Postgres.
3. 1:22Repo.
4. 4:38"Unbounded" Datasets
5. 12:23Social Graphs
6. 20:11Foreign Data Wrappers
7. 21:30Materialized Views
8. 23:30Range Types
9. 27:33Partial Indexes
10. 29:06Avoiding Race Conditions
11. 32:45Other Extensions
12. 33:37Web Sessions in your Database
13. 35:20Where I don't use Postgres

" related talks

• 46mUse PostgreSQL, not Rails, to make Rails Faster!Dan McClain · PostgresOpen 2014
• 34mPostgres 10, Performance, and YouGabe Enslein · RailsConf 2018
• 56mBreakout SessionBruce Momjian · PGConf Silicon Valley 2015
• 36mPostgres at any ScaleCraig Kerstiens · Birmingham on Rails 2020
• 31mUsing Databases to pull your applications weightHarisankar P S · RailsConf 2018
• 31mMaking Data DanceClark Barrett · RailsConf 2015
• 51mPostgreSQL, The Time-Series Database You WantChris Engelbert · Jfokus 2023
• 48mThe NoSQL Way in PostgreSQLVibhor Kumar · PostgresOpen 2014