Data modeling for those who want to save time and money!
summary
Postgres on Azure is practical: redesigning a normalized schema reduces storage by 15× smaller and cuts index bloat to 10× fewer indexes, replaces a separate NoSQL system with JSONB + GIN to avoid running another database, and steers choices between normalization and indexing based on the main operation. Use Azure Database for PostgreSQL Flexible Server (stop/start, right compute tier, reserved instances) and tune MVCC/autovacuum parameters to control write bloat and save money.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 0:37Postgres is built for the cloud
- 2:02Azure Database for Postgres
- 7:07Data modeling
- 11:12Data types
- 17:14Indexes
- 20:36The main operation
- 24:41The most performed operation
- 29:51Save money
related talks
26mWhat Enterprises like about Azure Database for PostgreSQL - Flexible Server
25mWhat’s New with Azure Database for PostgreSQL- Flexible Server
23mHow we keep Azure Database for PostgreSQL free of bloat to maximize disk space
56mSeamless Migration to Azure Database for PostgreSQL
32mWhat makes Azure Database for PostgreSQL Great for Developers?
28mDear Azure Database for PostgreSQL, can you automate my index?
24mPostgres-powered AI: Running an End-to-End AI Platform with Postgres on Azure
50mUnleashing the Power of Azure for PostgreSQL