DeepRead
Cover of PostgreSQL 9.0 High Performance

PostgreSQL 9.0 High Performance

Gregory Smith · 2010

Programming and computer science › Databases and distributed data

#2,861 most recommended

About the book

A practical guide to tuning and scaling PostgreSQL database servers, written around the 9.0 release. It covers the layers a busy database depends on, from hardware choice and operating system settings through memory configuration, query and index design, and the monitoring tools built into PostgreSQL and those available externally. The central claim is that PostgreSQL applications tend to hit the same performance problems in the same order as their load grows, so the warning signs can be learned in advance and many issues avoided. Performance work is presented as a repeating cycle: monitor each layer, rework the design and configuration based on what the measurements show, and only when a single server reaches its limits move to scaling techniques such as connection pooling, caching, partitioning, and replication.

Written by Claude from what it knows of this book.

What Hacker News says 86% recommend · 0% critical

02.55201020122014201620192013 peak · 5
This bookAverage book in Databases and distributed data

In the commenters’ own words

What Open Library readers say 4.00 from 1 rating

  1. 50
  2. 41
  3. 30
  4. 20
  5. 10
  • 3 want to read
  • 0 reading
  • 2 have read

Only 1 rating: treat the average as a hint.

Open Library’s page for the book

What critics say, via Wikipedia

No Wikipedia article about this book yet, so no critics to quote.

Reddit communities — coming later

The threads it came up in

Details

First published
2010
ISBN
9781849510301
Editions known
2 at Open Library
Open Library
OL15705612W

Bases de donnéesCOMPUTERSDatabase managementGestionInternetLogiciels libresOpen source softwarePostgreSQLProgramming LanguagesSQLSQL (Computer program language)SQL (Langage de programmation)

Explore in the mosaic

Read next: its neighbours on the mosaic