-
Book Overview & Buying
-
Table Of Contents
AI-Ready PostgreSQL 18
By :
Data types are fundamental to SQL. Choosing the optimal data type that accurately represents your domain, provides the right operators, and can comfortably hold your expected data range is key to creating high-performance databases. Once data types are chosen and we understand the query pattern, we can then select the optimal indexes.
The next chapter reviews the tools to monitor and manage the performance of queries and transactions. This includes understanding query execution plans, analyzing actual execution behavior, identifying missing or unused indexes, and knowing which tools to choose in the PostgreSQL ecosystem to monitor and manage a high-performance database.
Consult Chapter 11 of Learn SQL (Second Edition) by Luca Ferrari and Enrico Pirozzi, for a more detailed explanation of the MVCC mechanism in PostgreSQL.
Scan the QR code (or go to packtpub.com/unlock). Search for this...