SELECT 'amazing_features' FROM "postgresql"
summary
Practical tour of PostgreSQL features with concrete examples: using CTEs to simplify nested queries, window functions (filter, lag/lead, row_number) to compute analytics and remove duplicates — an example inserts ~1,000 films, adds 40 duplicates and deletes those 40 rows — and foreign data wrapper to query files, remote Postgres or Stripe as tables. Shows MERGE for upserts, LISTEN/NOTIFY for push events, ltree vs recursive CTEs for hierarchies, UUIDs instead of serials, timestamptz, and notes tests run on AlloyDB and mentions Yugabyte as a distributed option.
AI-written summary · about
chapters (18)
- 0:00PostgreSQL history
- 5:45Common Table Expressions
- 7:55Window functions
- 10:45Lag and Lead
- 12:33ROW_NUMBER deduplication
- 14:41JOIN LATERAL
- 16:53Serial IDs drawbacks
- 18:56UUIDs vs serial IDs
- 20:40Custom types for integrity
- 24:15MERGE command
- 28:09LISTEN and NOTIFY
- 30:18LTree hierarchy
- 33:10Recursive CTEs
- 34:14Foreign Data Wrappers
- 37:43Best practices
- 40:15Advanced features
- 42:03PostgreSQL distributions
- 43:48Conclusion
related talks
49mSELECT 'amazing features' FROM "postgresql"
29mSELECT 'amazing_features' FROM "postgresql"
48mSELECT 'amazing_features' FROM "postgresql"
44mSELECT 'amazing_features' FROM "posgresql"
34mSimple and Awesome Database Tricks
30mLesser known features of PostgreSQL
42mPostgreSQL Tips & Tricks For App Devs
29mPostgres Demystified