Architecture Required
Explore how PostgreSQL's architecture supports efficient data handling by performing processing within SQL queries. Understand the role of transactions for data consistency and durability, and learn how PostgreSQL serves as a powerful data access service using SQL as its API. This lesson helps you grasp the architecture needed to optimize performance and design effective software systems with PostgreSQL.
For accuracy it’s required that some processing happens in the SQL query—in many cases, having SQL do the data-related heavy lifting yields a net gain in performance characteristics. It mostly happens because round-trip latency, along with memory and bandwidth resource usage, depends directly on the size of the result sets.
The goal of this course is to provide us with new and powerful tools. Determining how and when to use them has to be done on a case-by-case basis. Still, a general approach is helpful in deciding how and where to implement application features.
Learning advanced SQL
The following concepts are important to keep in mind when learning advanced SQL.
Relational database management system (RDMS)
PostgreSQL is a relational database management system, and as ...