DB for next project? Why, Postgres, of course
summary
Claim: PostgreSQL nearly matches Oracle feature-for-feature while releasing yearly and powering massive deployments (Yahoo’s large cluster, Instagram, Skype, NASA). It ships as core PL/pgSQL plus PL/Perl, PL/Python, PL/Tcl, and version 9.6 is current in examples. Data types include XML, HStore, JSON and JSONB with indexes; foreign data wrappers replace many ETL jobs by exposing external tables. Internals use per-connection processes, shared buffers, MVCC and autovacuum for snapshots; cost estimates in EXPLAIN are page-fetch based and no optimizer hinting is enforced.
AI-written summary · about
chapters (21)
- 0:00Introduction and disclaimer
- 0:31DB Wars and Postgres history
- 3:07Postgres versions and support
- 3:48Chosen Postgres features
- 4:55Data length constraints and Python comparison
- 6:22Logging and query logging setup
- 11:27Stored procedures dilemma and scripting
- 13:39XML, JSON, and HStore data types
- 17:11Foreign data wrappers
- 18:14Windowing functions and CTEs
- 19:17Indexes and advanced data types
- 20:43Postgres process architecture
- 23:18Memory and query execution
- 25:38Query parsing and planning
- 28:53Explain and query analysis
- 31:22Explain analyze and performance
- 33:09Multithreading and MVCC
- 35:17Postgres stability and high-profile users
- 37:04Postgres advantages and disadvantages
- 39:10Learning curve and replication
- 40:01Q&A and closing
related talks
51mHow Postgres is Different (read BETTER than) your database
18mPostgres for the modern enterprise
15mBuilding for the Future and Betting Big on Postgres
29mPostgres Demystified
56mBreakout Session
49mPostgreSQL - the database-sister of Python
46mWhy PostgreSQL is becoming the standard in Financial Services
48mData Horizons With Postgres