PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries - Image 1

£31.98

Apress PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries

Name: PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
Brand: Apress
Price: 31.98 GBP
Availability: InStock

Applications

This is the most expensive it has ever been. Walk away.

£32 today · previous high £32 · all-time low £32

NEW HERE?

Amazon shows you one price. We show you all of them.

Tosheroon watches Amazon prices so you don't have to. Every product on Amazon has a price history — we make it visible. Set the price you'd actually pay, and we'll email you the second it gets there. No app, no account, one email.

WHAT'S ON THIS PAGE

↓ Price chart
when this has been cheap or pricey

↓ Forecast
where the price is heading next

↓ Statistics
all-time high & low, recent range

↑ Price alert
name your number, we'll email you

Price History & Forecast

Grey patches = out of stock. Cheaper = lower on the chart. Hover for exact prices.

Last 65 days · 65 data points (no recent data)

Historical

Generating forecast…

Price Distribution

Price distribution over 65 days • 1 price levels

Days at Price

Price Analysis

Most common price: £32 (65 days, 100.0%)

Price range: £32 - £32

Price levels: 1 different prices over 65 days

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

Product Specifications

Brand: Apress
Format: paperback
ASIN: B0CK5GWWQ1
Category: Books > Subjects > Computing & Internet > Databases > Applications
Domain: Amazon UK
Release Date: 09 January 2024
Listed Since: 30 September 2023

Barcode

No barcode data available

Apress PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries

This is the most expensive it has ever been. Walk away.

Price History & Forecast

Price Distribution

Price Analysis

Description

Product Specifications

Barcode

Similar Products You Might Like

SQL Server Query Tuning and Optimization: Optimize Microsoft SQL Server 2022 queries and applications

PostgreSQL 9.0 High Performance

PostgreSQL Mistakes and How to Avoid Them

PostgreSQL DA Handbook: PostgreSQL DATA ANALYST Handbook - Unlocking Insights with Advanced Database Techniques 110 Best Practices (GitHub link ... Data, with Unstructured Data, Advanced Skills

Query Processing in Database Systems (Topics in Information Systems)

PostGIS in Action, Third Edition

Pro T-SQL Programmer's Guide

Pro PowerShell for Database Developers

Oracle High-Performance SQL Tuning (DATABASE & ERP - OMG)

jOOQ Masterclass: A practical guide for Java developers to write SQL queries for complex database interactions

Deep Dive into the Power Platform in the Age of Generative AI: Architectural Insights and Best Practices for Intelligent Business Solutions

Windows Azure SQL Database Programming & Design

Pro WordPress: Mastering the Techniques for Building, Securing and Scaling Websites

Graph Databases in Action

Pro SQL Server Always On Availability Groups: Enterprise-level high-availability and disaster recovery

Pro JPA 2: Mastering the Java™ Persistence API (Expert's Voice in Java Technology)

Mastering REST APIs: Boosting Your Web Development Journey with Advanced API Techniques

Google BigQuery: The Definitive Guide: Data Warehousing, Analytics, and Machine Learning at Scale

High-Performance Programming in C# and .NET: Understand the nuts and bolts of developing robust, faster, and resilient applications in C# 10.0 and .NET 6

Data Engineering for Machine Learning Pipelines: From Python Libraries to ML Pipelines and Cloud Platforms

Mastering MongoDB 6.x: Expert techniques to run high-volume and fault-tolerant database solutions using MongoDB 6.x, 3rd Edition

Azure SQL Revealed: The Next-Generation Cloud Database with AI and Microsoft Fabric

Microsoft Copilot for Power Apps: Transforming App Development with AI Assistance (Inside Copilot)

Oracle Database 11g Sql (Oracle Press)