PostgreSQL Top Ten Features
summary
Postgres provides concrete, usable features: transactional DDL so CREATE/ALTER/DROP run inside transactions; true serializable isolation implemented to avoid anomalies; per-transaction synchronous_commit control so the app chooses durability; psql as a script runner; pgbench supports pgbench custom workloads with multi-session, percentage mixes and profiling; CREATE INDEX CONCURRENTLY runs two scans (cannot be inside another transaction) to avoid blocking; TEXT uses TOAST with trial compression to store up to 1GB; extensions install via CREATE EXTENSION.
AI-written summary · about
chapters (9)
- 0:00Intro
- 0:55Transactions
- 9:39Code Comments
- 13:19Parameters
- 16:22Secure Functions
- 23:31pgbench custom script
- 26:14synchronous_commit
- 30:34TEXT data type
- 34:29Extensibility
related talks
29m10 Features your Developers are missing when 'Stuck' with proprietary database!
51mHow Postgres is Different (read BETTER than) your database
34mPostgres 10, Performance, and You
44m10 reason why you should prefer PostgreSQL to
49mSELECT 'amazing features' FROM "postgresql"
45mSELECT 'amazing_features' FROM "postgresql"
43mWhy Postgres
29mPostgres Demystified