-
Book Overview & Buying
-
Table Of Contents
AI-Ready PostgreSQL 18
By :
Transactions and ACID compliance are key to reliable modern enterprise systems. PostgreSQL provides many tools to manage transactions and control the level of ACID compliance, so that the developer can make informed trade-offs between performance and application complexity.
While controlling and managing transactions is key to reliability, data modeling is essential to performance. A normalized data model avoids redundancy, increases performance, and simplifies query design.
In this chapter, you learned how to define transactions, how to control their execution and rollback, and how to choose the correct isolation level for an application. We also walked step by step through the data normalization process to help you create data models that avoid redundancy and undesirable internal dependencies.
In the next chapter, we will dive into the details of the PostgreSQL data types and indexes that you should use to create the data models and achieve high performance.
...