Road to Percona Live 2022 - Bruce Momjian - PostgreSQL Talk
summary
Step‑by‑step recipes for real work: installation options and exact configuration parameters to change, concrete commands for backup and recovery and for computing disk usage, how to control host connectivity and locate the query run by each session, plus clear differentiation of monitoring tools for realtime alerting versus historical trend analysis. Concrete non‑relational patterns: arrays, ranges, json and GIS with recommended indexes and examples of when they outperform separate engines. Risks section lists market, patent, and governance threats.
AI-written summary · about
chapters (5)
- 0:00Intro
- 0:23Mastering PostgreSQL
- 3:13Nonrelational PostgreSQL
- 6:11JSON PostgreSQL
- 7:32PostgreSQL Challenges
related talks
46mUse PostgreSQL to Step Up Your Game
21mDriving the Future of PostgreSQL Adoption
37mWhen it all goes Wrong (with Postgres)
56mLightning Talks
18mPower Hour, Managing Databases at Scale – Peter Zaitsev
46mPostgreSQL Analytics: It's a Trap!
21mGetting ready for PostgreSQL 9.1
49mSELECT 'amazing features' FROM "postgresql"