10 Features your Developers are missing when 'Stuck' with proprietary database!
summary
Claims ten concrete PostgreSQL features proprietary RDBMS users miss: native JSON columns and custom data types that avoid schema migration and let apps store semi‑structured records; user-defined operators and extensions for domain logic and case‑insensitive comparison; full‑text search with tsearch and trigram indexes; pgcrypto encryption and logical replication for compliance; COPY bulk load that ingests millions of rows quickly; partial/expression indexes that shrink index size and can be ~3x faster; ANALYZE stats that let the optimizer handle 1M‑row tables in minutes.
AI-written summary · about
chapters (23)
- 0:00Intro
- 0:20About me
- 1:50Why I love PostgreSQL
- 3:28Supported Platforms
- 4:40Features
- 5:38Indexing
- 6:19Feature Filter
- 8:18JSON Document
- 9:36Data Points
- 10:58Interval
- 11:37Data Types
- 12:48Fetch Data
- 13:25Integrating Data
- 15:19Operators
- 18:11Popular Extensions
- 19:44Partial Indexes
- 20:24Clear Indexes
- 21:00User Level Control
- 21:51Statistics
- 23:52Copy
- 24:45Gene Indexes
- 26:00Posters
- 26:54Questions
related talks
51mPostgreSQL Top Ten Features
29mPostgres Demystified
51mHow Postgres is Different (read BETTER than) your database
49mSELECT 'amazing features' FROM "postgresql"
44m10 reason why you should prefer PostgreSQL to
43mWhy Postgres
44mSELECT 'amazing_features' FROM "posgresql"
49m3+ Features Developers Use That Might Never Make It to PostgreSQL