
PostgreSQL 9.0 High Performance
Gregory Smith · 2010
Programming and computer science › Databases and distributed data
#2,861 most recommended
Hacker News
19
mentions by 14 people · top 17% of 15,732 books
Open Library
4.00★★★★★★★★★★
1 rating · 3 want to read
Wikipedia
—
No article yet
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
In the commenters’ own words
You should try to understand how databases in general work, it will help you with your query writing. One thing you have to realize is that once you get a…
PostgreSQL is hands down the way to go when you need a relational DB (which is 99% of the time). Some features to read up on: * COALESCE, CASE * Aggregate…
What Open Library readers say 4.00 from 1 rating
- 50
- 41
- 30
- 20
- 10
- 3 want to read
- 0 reading
- 2 have read
Only 1 rating: treat the average as a hint.
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)
Read next: its neighbours on the mosaic
PostgreSQL 16 Administration CookbookGianni Ciolli · 2023 · recommended by 2 people · similar by subject and what people say about it
Joe Celko's SQL for SmartiesJoe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
High Performance MySQLJeremy D. Zawodny · 2004 · recommended by 27 people · similar by subject and what people say about it
SQL Performance ExplainedMarkus Winand · 2011 · recommended by 26 people · similar by subject and what people say about it
Python For Data AnalysisWes McKinney · 2012 · recommended by 29 people · 2 people recommended both
Systems PerformanceBrendan Gregg · 2013 · recommended by 32 people · similar by subject and what people say about it
The Art of PostgreSQLDimitri Fontaine · 2019 · recommended by 20 people · similar by subject and what people say about it
Developing time-oriented database applications in SQLRichard T. Snodgrass · 1999 · recommended by 6 people · similar by subject and what people say about it
Designing Data-Intensive ApplicationsMartin Kleppmann · 2017 · recommended by 457 people · 2 people recommended both
MySQL High AvailabilityCharles Bell · 2014 · recommended by 2 people · similar by subject and what people say about it
SQL antipatternsBill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
Practice of Cloud System AdministrationThomas Limoncelli · recommended by 8 people · similar by subject and what people say about it
The data warehouse toolkitRalph Kimball · 1996 · recommended by 23 people · similar by subject and what people say about it
High Performance JavaScriptNicholas C. Zakas · 2010 · recommended by 14 people · similar by subject and what people say about it
Seven Databases in Seven WeeksEric Redmond · 2012 · recommended by 8 people · similar by subject and what people say about it
Operating System ConceptsAbraham Silberschatz · 1982 · recommended by 26 people · similar by subject and what people say about it
Programming Ruby 1.92010 · recommended by 11 people · similar by subject and what people say about it
Database InternalsAlex Petrov · 2019 · recommended by 31 people · similar by subject and what people say about it
Practical File System DesignDominic Giampaolo · 2013 · recommended by 15 people · similar by subject and what people say about it
Graphics gemsAndrew S. Glassner · 1990 · recommended by 15 people · similar by subject and what people say about it
Time Management for System AdministratorsThomas Limoncelli · 2005 · recommended by 19 people · similar by subject and what people say about it
High Performance Web SitesSteve Souders · 2007 · recommended by 8 people · similar by subject and what people say about it
High Performance PythonMicha Gorelick · 2014 · recommended by 8 people · similar by subject and what people say about it
High Performance Browser NetworkingIlya Grigorik · 2013 · recommended by 58 people · similar by subject and what people say about it