Data modeling for those who want to save time and money! | Citus Con: An Event for Postgres 2022

148 Aufrufe
Published
Video of a talk presented by Danielle Monteiro at Citus Con: An Event for Postgres. Abstract: Using a database as powerful as PostgreSQL challenges us to use best practices to get the best performance within the expected cost... But two aspects that are often overlooked is data modeling and governance.

The PostgreSQL or Citus data projects that start right are the ones that will succeed! Choosing the best indexes and the best data types is critical to success—and if your application runs on Azure, choosing the best scaling of these services on Azure matters too! And if your application already exists, and is running on top of PostgreSQL, what improvements are feasible? Let's talk about real-life tuning.

If we put this database triad together (best practices, data modeling, and data governance) it is practically impossible for your project not to be a great success! Join me in this talk and let's go together towards successful projects.

Danielle Monteiro has a Masters in Computer Engineering, is a TEDx Speaker, and is passionate about data and databases. After years as a developer, she has been a DBA, architect, and data engineer—and now she is CSA (Data and AI) at Microsoft.

► Video bookmarks:
⏩ 00:00 Introduction
⏩ 00:37 Postgres is built for the cloud
⏩ 02:02 Azure Database for Postgres
⏩ 07:07 Data modeling
⏩ 11:12 Data types
⏩ 17:14 Indexes
⏩ 20:36 The main operation
⏩ 24:41 The most performed operation
⏩ 29:51 Save money

✅ Learn more:
Watch more Citus Con talks: https://aka.ms/cituscon-playlist

Kategorien
Windows Reparieren
Kommentare deaktiviert.