Goodreads helps you keep track of books you want to read.
Start by marking “PostgreSQL 9.0 High Performance: Accelerate Your PostgreSQL System and Avoid the Common Pitfalls That Can Slow It Down” as Want to Read:
Blank 133x176
PostgreSQL 9.0 High Pe...
 
by
Gregory Smith
Rate this book
Clear rating
Open Preview

PostgreSQL 9.0 High Performance: Accelerate Your PostgreSQL System and Avoid the Common Pitfalls That Can Slow It Down

4.27  ·  Rating details ·  102 ratings  ·  16 reviews
Accelerate your PostgreSQL system. Improving database performance requires an equal mix of understanding theoretical concepts and working through hands-on examples. You'll find both here. Many of the examples given will be immediately useful for monitoring and improving your PostgreSQL deployments, providing insight into hard-to-obtain information about your database. This ...more
ebook, 469 pages
Published May 14th 2014 by Packt Publishing (first published October 18th 2010)
More Details... edit details

Friend Reviews

To see what your friends thought of this book, please sign up.

Reader Q&A

To ask other readers questions about PostgreSQL 9.0 High Performance, please sign up.

Be the first to ask a question about PostgreSQL 9.0 High Performance

This book is not yet featured on Listopia. Add this book to your favorite list »

Community Reviews

Showing 1-30
4.27  · 
Rating details
 ·  102 ratings  ·  16 reviews


More filters
 | 
Sort order
Stefan Kanev
Sep 24, 2014 rated it it was amazing  ·  review of another edition
This book is awesome. It may take quite a while to internalize all the useful stuff that it says about PostgreSQL. Just the chapter about Query Optimization is worth buying it for.

The author is an experienced PostgreSQL administrator and he shares quite a lot of experience. If you're a programmer, it will help you understand a lot of things about PostgreSQL performance that you have never considered before – hard disk configuration and performance, the importance of the Write-Ahead Log and chec
...more
Ingmar
Sep 23, 2013 rated it it was ok  ·  review of another edition
Definitely full of useful advice, often with detailed background information. Like many tech books, it suffers a bit from the fact that the author is more engineer than author, and apparently also was under the impression (or contract) of having to deliver a certain amount of words, making the book unnecessarily verbose in places.
Maciek
Jan 04, 2011 rated it really liked it  ·  review of another edition
Excellent info. The only complaint is that the prose is a little awkward in a number of places--the book could've used a more thorough editing pass.
Bernie
Dec 05, 2014 rated it really liked it  ·  review of another edition
I picked up this text in a previous role in order to complete certain tasks that had me working with a PG database.

Speaking as a newcomer wih no DBA experience, from simple SQL to more advanced DBA concepts, this certainly gave me the background I needed to get going; it would seem, a lot of material left over to master.
Dariusz
Jul 22, 2016 rated it it was amazing  ·  review of another edition
Shelves: informatyka, owned
Świetna książka, obejmująca szeroki zakres tematów związanych z optymalizacją baz danych, począwszy od wyboru sprzętu do optymalizacji zapytań (choć ten ostatni temat mógł być szerzej i dokładniej omówiony). Bardzo przydatne rozdziały o konfiguracji systemu pod serwer i monitorowania jego wydajności.
Mark McGranaghan
Aug 17, 2014 rated it really liked it  ·  review of another edition
A useful survey of performance-related Postgres issues. Obviously based on extensive experience with Postgres in production environments. My only problem with the book is that it feels slightly out of date, e.g. describing SSDs as "an unknown risk for database use [that] should be approached with caution.". Still worth reading for sure if you're running Postgres in production though.
Amrullah Zunzunia
This book has wealth of information, but is written for database administrators. but even as a developer, I found some useful information (especially about indexes). I wish this book covered topic of materialized views in depth ( which it doesn't)
Dave Peticolas
All about making Postgres go fast, everything from low-level disk I/O to query optimization and more. The chapter on using EXPLAIN was worth the price of the book.
Ivaylo
Sep 26, 2016 rated it it was amazing  ·  review of another edition
Една от най-добрите "down-to-business" книги изобщо. Общите теми са безкрайно полезни, а конкретно "query optimization" е ЗАДЪЛЖИТЕЛНА за всеки сериозен разработчик. За "съжаление" PG се развива бясно и книжката поостарява - бързайте :)
Paweł Sobiegraj
Przeczytałem z niej to co było mi potrzebne. Dużo ciekawych przykładów, a co ważniej dokładnie omówione mechanizmy i sztuczki w PostgeSQL.
Evgeniy Vasilev
Jan 22, 2013 rated it it was amazing
It may take years to fully comprehend all of the details mentioned in this book.
Bartek
Aug 20, 2013 rated it really liked it  ·  review of another edition
nigdy
Alexandr Kurilin
Fantastic read, very much in depth look into what it takes to run PostgreSQL at full capacity, fully utilizing all of the available hardware.
Bharat
Mar 26, 2015 rated it really liked it  ·  review of another edition
Amazing information throughout that is not covered in the Postgres documentation. Chapter on Query Optimization is an example to illustrate this.
Alexey Makarov
Sep 05, 2014 rated it it was amazing  ·  review of another edition
Великолепная книга по оптимизации БД PostgreSQL.
Kaixi Luo
Jul 10, 2016 rated it it was amazing  ·  review of another edition
Shelves: paused
Outstanding book about Postgresql internals, tuning and performance.
NITIN DUBEY
rated it it was amazing
Dec 06, 2018
Joel
rated it really liked it
Sep 03, 2014
Joe
rated it really liked it
Oct 26, 2011
Tanel
rated it really liked it
Jul 29, 2013
Ostap Maliuvanchuk
rated it really liked it
May 01, 2017
Wes
rated it it was amazing
Nov 15, 2011
James
rated it really liked it
Dec 12, 2012
Paweł Marczewski
rated it liked it
Feb 08, 2015
Rene Romero Benavides
rated it it was amazing
Jun 19, 2014
Nicola
rated it really liked it
Jun 02, 2013
Nicholas Edwards
rated it it was amazing
Mar 16, 2019
Daniel Huckstep
rated it it was amazing
Nov 03, 2013
Aleksandar Erkalovic
rated it it was amazing
Mar 02, 2013
Andrew
rated it it was amazing
May 16, 2012
« previous 1 3 4 next »
There are no discussion topics on this book yet. Be the first to start one »