PostgreSQL Query Optimization

Więcej o książce

This book helps you write fast-performing queries and deliver timely results. Query optimization is accessible to any motivated professional, enabling you to create efficient queries and optimize existing ones. You'll learn to approach query writing from the database engine's perspective and think like a database optimizer. The content begins with defining a performant system, measuring performance, and setting goals. It introduces various query types and optimization techniques, including index usage and specific join algorithms. You'll gain skills in reading and understanding query execution plans and learn how to influence them for better performance. Advanced topics such as functions, procedures, dynamic SQL, and generated queries are also covered, all aimed at producing high-performance applications while avoiding common pitfalls of object-relational mappers. This second edition features new examples with Postgres 15 and the latest PostgresAir database, along with enhanced details on advanced topics and configuration parameters. It also incorporates advancements in NORM, utilizing automatically generated functions. Ideal for IT professionals in PostgreSQL, database developers, administrators, backend developers, and system architects focused on scalable application design.