How Postgres is Different (read BETTER than) your database
summary
Claims that PostgreSQL can replace Oracle/DB2 for enterprise workloads, and that it behaves as a platform not just a database, are supported by concrete features: range types + exclusion constraints to prevent double bookings, per-transaction synchronous replication for durable failover, SSI serializability, index-only scans and synchronized sequential scans for faster queries, JSON/edge-store types and PostGIS extensions that actually run. Diagnostics use pg_stat views log_temp_files and systemtap. Surprising numbers: large objects to 4 TB, job listings up ~2250% over years, commercial support ~ $4–5k per socket.
AI-written summary · about
chapters (59)
- 0:00Introduction
- 1:09Postgres as enterprise platform
- 2:14Developer features overview
- 3:18License model
- 5:49ACID compliance
- 7:14Data integrity
- 8:18Security features
- 9:22Postgres beyond database
- 10:04CTEs and data types
- 11:10Advanced data types
- 14:18Intervals and enums
- 15:43Geometry and network types
- 16:24Range and composite types
- 17:28Arrays and extensibility
- 18:30NoSQL with hstore and JSON
- 19:10Replication and high availability features
- 20:15Synchronous replication
- 21:17Serializable transactions
- 21:37Listen/Notify
- 22:39Exclusion constraints
- 23:44Operator overloading
- 24:27Large objects and materialized views
- 25:29Stored procedures
- 25:50PL/JavaScript
- 26:34TOAST for large data
- 27:16Performance optimizations
- 27:36Cost-based optimizer
- 28:17Sequential scans
- 29:19Table partitioning
- 30:02Partial indexes
- 30:44Index types
- 31:49Why index types matter
- 32:14Join strategies
- 33:20Bitmap scans
- 34:01Postgres vs MongoDB
- 34:49Diagnosing issues
- 35:11Virtual views
- 35:33pg_stat_activity
- 35:53pg_locks analysis
- 36:15Table/index stats
- 36:35Replication monitoring
- 36:57Slow query logs
- 37:17Temp files logs
- 37:58Systemtap tracing
- 38:59Custom types
- 39:19CREATE EXTENSION
- 40:01PGXN extensions
- 40:46Foreign Data Wrappers
- 41:28PostGIS
- 42:51Approximate count
- 43:14Manager perspective
- 43:35Cost savings
- 44:16Zero acquisition cost
- 45:00Community vs commercial
- 46:24Job market growth
- 47:26Major vendors
- 48:30Maintenance costs
- 49:38Consulting and training
- 49:59Convincing management
related talks
29mPostgres Demystified
40mDB for next project? Why, Postgres, of course
46mWhy PostgreSQL is becoming the standard in Financial Services
56mBreakout Session
43mWhy Postgres
01h 09mReplacing Oracle Features in PostgreSQL: HA, Functions & Extensibility
29m10 Features your Developers are missing when 'Stuck' with proprietary database!
25mThe Rise of PostgreSQL as the Everything Database