Optimization of PostgreSQL queries
Please sign in so that we can notify you about a reply
This book will help you write requests that are executed quickly and deliver results in time. After reading it, you will learn how to look at the process of writing a request from the point of view of the database mechanism and begin to think as an optimizer of the database.
The first chapters of the book tells what an effective system is, how to measure performance and set the targets associated with this indicator. Various classes of requests are presented and optimization methods suitable for each of them, such as the use of indices and certain compound algorithms. It is explained how to read and understand plans for execution of requests, what methods of influence on these plans exist in terms of performance optimization. The following are difficult topics: the use of functions and procedures, dynamic SQL and generated requests. It is shown how these methods are used together to create effective applications.
The book is intended for IT specialists who want to develop productive and scalable applications. It will be useful to developers and database administrators, those who develop the server part and are responsible for writing calls to databases, as well as system architects participating in the design of application systems using the PostgreSQL database
The first chapters of the book tells what an effective system is, how to measure performance and set the targets associated with this indicator. Various classes of requests are presented and optimization methods suitable for each of them, such as the use of indices and certain compound algorithms. It is explained how to read and understand plans for execution of requests, what methods of influence on these plans exist in terms of performance optimization. The following are difficult topics: the use of functions and procedures, dynamic SQL and generated requests. It is shown how these methods are used together to create effective applications.
The book is intended for IT specialists who want to develop productive and scalable applications. It will be useful to developers and database administrators, those who develop the server part and are responsible for writing calls to databases, as well as system architects participating in the design of application systems using the PostgreSQL database
Author:
Author:Домбровская Генриэтта
Cover:
Cover:Hard
Category:
- Category:Computer & Technology
ISBN:
ISBN:978-5-97060-963-7
No reviews found