Data Modeling for Saving Time and Money in PostgreSQL - Best Practices and Optimization

Explore data modeling best practices to optimize PostgreSQL performance and reduce costs in this conference talk from Citus Con: An Event for Postgres 2022. Discover how to leverage PostgreSQL's power through effective data modeling and governance techniques. Learn about choosing optimal indexes and data types, scaling services on Azure, and implementing feasible improvements for existing applications. Gain insights into the database triad of best practices, data modeling, and data governance to ensure project success. Benefit from real-life tuning examples and expert advice on saving time and money while maximizing PostgreSQL's capabilities.

Introduction.
Postgres is built for the cloud.
Azure Database for Postgres.
Data modeling.
Data types.
Indexes.
The main operation.
The most performed operation.
Save money.