PostgreSQL Query Optimization

PostgreSQL Query Optimization

Author: Henrietta Dombrovskaya

Publisher: Apress

ISBN: 1484268849

Category: Computers

Page: 280

View: 678

Download Now
Write optimized queries. This book helps you write queries that perform fast and deliver results on time. You will learn that query optimization is not a dark art practiced by a small, secretive cabal of sorcerers. Any motivated professional can learn to write efficient queries from the get-go and capably optimize existing queries. You will learn to look at the process of writing a query from the database engine’s point of view, and know how to think like the database optimizer. The book begins with a discussion of what a performant system is and progresses to measuring performance and setting performance goals. It introduces different classes of queries and optimization techniques suitable to each, such as the use of indexes and specific join algorithms. You will learn to read and understand query execution plans along with techniques for influencing those plans for better performance. The book also covers advanced topics such as the use of functions and procedures, dynamic SQL, and generated queries. All of these techniques are then used together to produce performant applications, avoiding the pitfalls of object-relational mappers. What You Will Learn Identify optimization goals in OLTP and OLAP systems Read and understand PostgreSQL execution plans Distinguish between short queries and long queries Choose the right optimization technique for each query type Identify indexes that will improve query performance Optimize full table scans Avoid the pitfalls of object-relational mapping systems Optimize the entire application rather than just database queries Who This Book Is For IT professionals working in PostgreSQL who want to develop performant and scalable applications, anyone whose job title contains the words “database developer” or “database administrator" or who is a backend developer charged with programming database calls, and system architects involved in the overall design of application systems running against a PostgreSQL database
PostgreSQL Query Optimization
Language: en
Pages: 280
Authors: Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova
Categories: Computers
Type: BOOK - Published: 2021-05-27 - Publisher: Apress

Write optimized queries. This book helps you write queries that perform fast and deliver results on time. You will learn that query optimization is not a dark art practiced by a small, secretive cabal of sorcerers. Any motivated professional can learn to write efficient queries from the get-go and capably
PostgreSQL
Language: en
Pages: 790
Authors: Korry Douglas, Susan Douglas
Categories: Computers
Type: BOOK - Published: 2003 - Publisher: Sams Publishing

"PostgreSQL" leads users through the internals of an open-source database. Throughout the book are explanations of data structures and algorithms, each backed by a concrete example from the actual source code. Each section contains information about performance implications, debugging techniques, and pointers to more information (on the Web and in
PostgreSQL 9.0 Official Documentation - Volume V. Internals and Appendixes
Language: en
Pages: 484
Authors: Postgresql Global Development Group
Categories: Computers
Type: BOOK - Published: 2011-03 - Publisher: Fultus Corporation

This book is part of the PostgreSQL 9.0 documentation collection (up-to-date & full), published by Fultus Corporation. PostgreSQL 9.0 includes built-in, binary replication, and over a dozen other major features which will appeal to everyone from web developers to database hackers.
PostgreSQL 10 High Performance
Language: en
Pages: 508
Authors: Enrico Pirozzi
Categories: Computers
Type: BOOK - Published: 2018-04-30 - Publisher: Packt Publishing Ltd

PostgreSQL is increasingly utilized in all kind of applications, starting from desktop to web and mobile applications. In this book, you will find the best ways to design, monitor and maintain your PostgreSQL solution, with suggestions and tips for high performance, troubleshooting and high availability.
Implementing the PostgreSQL Query Optimizer Within the OPT++ Framework
Language: en
Pages:
Authors: Ju Wang
Categories: Computers
Type: BOOK - Published: 2002 - Publisher:

Books about Implementing the PostgreSQL Query Optimizer Within the OPT++ Framework