Use PostgreSQL to Step Up Your Game
summary
Concrete PostgreSQL techniques are presented: using native types like inet, generate_series to create test rows, domains and computed columns, and list/hash partitioning with a default partition plus SSD tablespace placement. The talk covers PostgreSQL 15 JSONB/jsonpath features, dynamic anonymization via a Dalibo extension, row-level security policies parsed from role names, scheduling with pg_cron, PL/Python functions, and a custom Python FDW that retrieves Chuck Norris jokes.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 3:09Advanced data types
- 7:43Data generation and anonymization
- 12:59Table partitioning
- 16:09Data security
- 21:49Dynamic access control
- 28:54Automation with cron
- 30:43Functions in other languages
- 34:03Foreign tables and Data Wrapper
- 41:00Advanced JSON manipulation
