Road to Percona Live 2022 - Andreas Scherbaum - PostgreSQL Talk
summary
Demonstrates that choosing the right data type changes performance — a demo swaps primary keys from int to varchar vs int primary key and performance tanks — and shows how to create your own data type in PostgreSQL and use it successfully. Uses Ansible to install and configure PostgreSQL, including playbooks that create databases users tables and indexes. Notes a surprising industry stat: more than 1,000 databases in over 40% of companies, motivating automation with concrete configs and working demos.
AI-written summary · about
chapters (4)
related talks
46mUse PostgreSQL to Step Up Your Game
21mDriving the Future of PostgreSQL Adoption
45mMake Your SQL Queries 10,000x Faster, for Good
46mPostgreSQL Analytics: It's a Trap!
34mSimple and Awesome Database Tricks
31mBeyond Agents: Why You Should Still Care About Database Internals
36mPostgreSQL: Ups, DevOps...
49mSELECT 'amazing features' FROM "postgresql"