Buy new:
£38.51
RRP: £39.99

This is the retail price by the manufacturer or importer of the product. Amazon confirms the relevance of this RRP, on a quarterly basis, compared to prices charged by at least one competitor or Amazon.
Learn more
Save: £1.48 (4%)
& FREE Returns
Return this item for free
  • Free returns are available for the shipping address you chose. For a full refund with no deduction for return shipping, you can return the item for any reason in new and unused condition.
  • Learn more about free returns.
FREE delivery Tuesday, August 23. Details
Or fastest delivery Tomorrow, August 20. Order within 14 hrs 20 mins. Details
In stock.
As an alternative, the Kindle eBook is available now and can be read on any device with the free Kindle app.
[{"displayPrice":"£38.51","priceAmount":38.51,"currencySymbol":"£","integerValue":"38","decimalSeparator":".","fractionalValue":"51","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"6q%2BkDv4jfvguOkKw0TwUndye0zhKCP4Lq0RHNEu3g%2FvSLElfMZKtkKLYVXakeRL%2Bxst5xKqd8NN%2F0kk1j%2Bj8luSCQKzW%2BmBe5oU63oARknbdOn98uc%2Fl8MbBGtT9BmV4","locale":"en-GB","buyingOptionType":"NEW"}]
££38.51 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
££38.51
Subtotal
Initial payment breakdown
Delivery cost, delivery date and order total (including tax) shown at checkout.
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Dispatches from
Amazon
Sold by
Amazon
Dispatches from
Amazon
Sold by
Amazon
Return policy: Returnable within 30 days of receipt
Item can be returned in its original condition for a full refund or replacement within 30 days of receipt
PostgreSQL Query Optimiza... has been added to your Basket
Share <Embed>
Have one to sell?
Kindle app logo image

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.

QR code to download the Kindle App

Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more

PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries Paperback – 23 April 2021

4.5 out of 5 stars 19 ratings

Amazon Price
New from Used from
Kindle Edition
Paperback
£38.51
£30.69 £30.82
Note: This item is eligible for FREE Click and Collect without a minimum order subject to availability. Details
Pick up your parcel at a time and place that suits you subject to availability.
  • Choose from over 20,000 locations across the UK
  • FREE unlimited deliveries at no additional cost for all customers
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more

Enhance your purchase

School Books
From pre-school to A-levels, find School Books for all ages Shop now

Frequently bought together

  • PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
  • +
  • Mastering PostgreSQL 13: Build, administer, and maintain database applications efficiently with PostgreSQL 13, 4th Edition
Total price:
To see our price, add these items to your basket.
Choose items to buy together.

Product description

From the Back Cover

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.

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

Henrietta Dombrovskaya is a database researcher and developer with over 35 years of academic and industrial experience. She holds a PhD in computer science from the University of Saint Petersburg, Russia. At present, she is Associate Director of Databases at Braviant Holdings, Chicago, Illinois. She is an active member of the PostgreSQL community, a frequent speaker at the PostgreSQL conference, and a local organizer of the Chicago PostgreSQL User Group. Her research interests are tightly coupled with practice and are focused on developing efficient interactions between applications and databases. She is a winner of the “Technologist of the Year” 2019 award of the Illinois Technology Association.
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.

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
  • Customer reviews:
    4.5 out of 5 stars 19 ratings

Customer reviews

4.5 out of 5 stars
4.5 out of 5
19 global ratings
5 star
70%
4 star
22%
3 star 0% (0%) 0%
2 star 0% (0%) 0%
1 star
8%

No customer reviews

There are 0 customer reviews and 19 customer ratings.