Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

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

Microsoft via YouTube

Overview

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.

Syllabus

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.

Taught by

Microsoft Developer

Reviews

Start your review of Data Modeling for Saving Time and Money in PostgreSQL - Best Practices and Optimization

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.