So you're new to Postgres...
summary
Quick newcomer roadmap: Postgres guarantees ACID and MVCC for data integrity, releases a new major version roughly every year (four active release lines right now), and 9.0 brought binary replication while 9.4 adds jsonb in 9.4. Practical tools covered: use psql backslash commands for exploration, serial columns create transaction‑safe sequences with unavoidable gaps, indices (partial, functional, multi‑column) and foreign key indices matter, foreign data wrappers let Postgres query CSVs, MySQL or other sources, and PGXN/PostGIS expand functionality.
AI-written summary · about
chapters (19)
- 0:00Postgres introduction
- 1:15Naming conventions and history
- 5:59Version numbers and releases
- 10:33Postgres ownership and community
- 12:42Where to find Postgres help
- 23:11Random tips for new users
- 24:57ACID and transactions in Postgres
- 27:52NULLs and joins in queries
- 31:07Referential integrity and foreign keys
- 33:12Indices and their types
- 36:02Primary keys and auto-increment
- 38:15Essential psql commands
- 40:22Advanced Postgres features
- 43:34Foreign data wrappers and PostGIS
- 44:17JSON support and languages
- 45:41Tuning Postgres config
- 46:24Monitoring space and index bloat
- 46:45Postgres extensions and PL/LawCode
- 47:27Q&A
