
Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet or computer - no Kindle device required. Learn more.
Read instantly on your browser with Kindle Cloud Reader.
Using your mobile phone camera - scan the code below and download the Kindle app.


PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries Paperback – 23 April 2021
- Choose from over 20,000 locations across the UK
- FREE unlimited deliveries at no additional cost for all customers
- Find your preferred location and add it to your address book
- Dispatch to this address when you check out
Enhance your purchase
- ISBN-101484268849
- ISBN-13978-1484268841
- Edition1st ed.
- Publication date23 April 2021
- LanguageEnglish
- Dimensions17.81 x 1.98 x 25.4 cm
- Print length342 pages
What other items do customers buy after viewing this item?
Product description
From the Back Cover
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.
You will:
- 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
About the Author
Boris Novikov is currently a professor in the Department of Informatics at National Research University Higher School of Economics in Saint Petersburg, Russia. He graduated from Leningrad University’s School of Mathematics and Mechanics. He has worked for Saint Petersburg University for a number of years and moved to his current position in January, 2019. His research interests are in a broad area of information management and include several aspects of design, development, and tuning of databases, applications, and database management systems. He also has interests in distributed scalable systems for stream processing and analytics.
Anna Bailliekova is Senior Data Engineer at Zendesk. Previously, she built ETL pipelines, data warehouse resources, and reporting tools as a team lead on the Division Operations team at Epic. She has also held analyst roles on a variety of political campaigns and at Greenberg Quinlan Rosner Research. She received her undergraduate degree cum laude with College Honors in political science and computer science from Knox College in Galesburg, Illinois.
Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.
Product details
- Publisher : Apress; 1st ed. edition (23 April 2021)
- Language : English
- Paperback : 342 pages
- ISBN-10 : 1484268849
- ISBN-13 : 978-1484268841
- Dimensions : 17.81 x 1.98 x 25.4 cm
- Best Sellers Rank: 250,455 in Books (See Top 100 in Books)
- 86 in Beginner's Guide to Databases
- 108 in Database Management Systems (Books)
- 141 in UNIX & Linux
- Customer reviews:
Customer reviews
Customer Reviews, including Product Star Ratings, help customers to learn more about the product and decide whether it is the right product for them.
To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyses reviews to verify trustworthiness.
Learn more how customers reviews work on Amazon