PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries by Dombrovskaya, Henrietta
PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries by Dombrovskaya, Henrietta

PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries

Write optimized queries. This book helps you write queries that perform fast and deliver results on time....
$100.87 SGD
$100.87 SGD
SKU: 9798868800689
Product Type: Books
Please hurry! Only 0 left in stock
Author: Henrietta Dombrovskaya
Format: Paperback
Language: English
Subtotal: $100.87
10 customers are viewing this product
PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries by Dombrovskaya, Henrietta

PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries

$100.87
PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries by Dombrovskaya, Henrietta

PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries

$100.87
Author: Henrietta Dombrovskaya
Format: Paperback
Language: English
Description

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.

This second edition includes new examples using Postgres 15 and the newest version of the PostgresAir database. It includes additional details and clarifications about advanced topics, and covers configuration parameters in greater depth. Finally, it makes use of advancements in NORM, using automatically generated functions.


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


Author: Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova
Publisher: Apress
Published: 01/21/2024
Pages: 344
Binding Type: Paperback
ISBN: 9798868800689
Shipping & Return

Returns Policy

You may return most new, unopened items within 30 days of delivery for a full refund. We'll also pay the return shipping costs if the return is a result of our error (you received an incorrect or defective item, etc.).

You should expect to receive your refund within four weeks of giving your package to the return shipper, however, in many cases you will receive a refund more quickly. This time period includes the transit time for us to receive your return from the shipper (5 to 10 business days), the time it takes us to process your return once we receive it (3 to 5 business days), and the time it takes your bank to process our refund request (5 to 10 business days).

If you need to return an item, simply login to your account, view the order using the "Complete Orders" link under the My Account menu and click the Return Item(s) button. We'll notify you via e-mail of your refund once we've received and processed the returned item.

Shipping

We can ship to virtually any address in the world. Note that there are restrictions on some products, and some products cannot be shipped to international destinations.

When you place an order, we will estimate shipping and delivery dates for you based on the availability of your items and the shipping options you choose. Depending on the shipping provider you choose, shipping date estimates may appear on the shipping quotes page.

Please also note that the shipping rates for many items we sell are weight-based. The weight of any such item can be found on its detail page. To reflect the policies of the shipping companies we use, all weights will be rounded up to the next full pound.

Review

Related Products

Example product title
$100.87 SGD
$100.87 SGD
Example product title
$100.87 SGD
$100.87 SGD
Example product title
$100.87 SGD
$100.87 SGD
Example product title
$100.87 SGD
$100.87 SGD
Example product title
$100.87 SGD
$100.87 SGD
Example product title
$100.87 SGD
$100.87 SGD
Example product title
$100.87 SGD
$100.87 SGD
Example product title
$100.87 SGD
$100.87 SGD
Example product title
$100.87 SGD
$100.87 SGD
Example product title
$100.87 SGD
$100.87 SGD

Recently Viewed Products