April 2021
Intermediate to advanced
335 pages
6h 49m
English
book
PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
by Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova
Content preview from PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient QueriesBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Index
A
age_category_dyn function
age_category function
Algorithm cost models
Algorithms
comparing
hash-based
sort-merge
Application Development and Performance
impedance mismatch
interfaces
ORM
patterns
performance metrics
response time
shopping list problem
solution
world wide wait
Avoiding multiple scans
attributes
black box
collapsing
custom_field table
EAV table
first/last names
larger table
one table scan
postgres_air
sorting
subquery
B
Bitmaps
booking_leg table
Boolean search model
B-tree indexes
blocks
cost
CPU
data type
keys
leaf nodes
non-leaf nodes
range search
root nodes
C
coalesce() function
Common table expressions (CTEs)
behavior
execution plan
forced materialization
MATERIALIZED/NOT MATERIALIZED
optimization fence
PostgreSQL
query
SQL statement
temporary tables
Compound indexes
arrival_airport/scheduled_departure ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.