The second edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL. You will be lead through the internals of the powerful PostgreSQL open source database chapter, offering an easy-to-read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This definitive guide to building, programming and administering the powerful PostgreSQL open-source database system will help you harness one of the most widely used open source, enterprise-level database systems.
Customer Reviews
Average Rating:
Rating: - PostgreSQL (2nd Ed) worth having
As a developer with many years IT experience in control systems and only a little in databases and none with Postgres, I found this book to be extremely helpful. It covered a huge amount of topics with examples and put them together in a way that made it more efficient than googling!
It helped that I knew what topics I needed in looking for answers but the chapters were self explantory in the topics they covered which I believe would allow a beginner to make quick progress in learning ... Read More
Rating: - Comprehensive introduction to PostgreSQL
I am a database application developer with MS SQL Server, Oracle, Sybase and many other RDBMSs experience.
This book allowed me to start working on PostgreSQL immediately.
Pro: comprehensive, good examples, good supplement to the documentation.
Cons: is not deep enough for me (does not explain format of a transaction log file or WAL file, for example), but, I guess, I should read the PostgreSQL code for this.
If you are new to databases you would need to read some other books ... Read More
Rating: - Disappointed with a serious error
I'm upset that this book that I've been trusting for the past month or two has such an egregious error in its discussion of regular expressions on page 51. I wish the authors had left out any discussion of regexes if they weren't going to actually test their assumptions about a topic on which I assume they know little. :-(
Rating: - Excellent resource for any PostgreSQL admin
PostgreSQL 2nd Edition is a phenomenal book if you're a programmer, and a great book if you're a non-programming admin. As someone whose programming ability reaches only ever so slightly beyond bash scripting and WSH, the parts of this book that were really worthwhile to me were those devoted to the administration of PostgreSQL. Backing up, recovering, and performance tuning were excellent resources, especially to someone who had never set up or administered a database. Speaking of which, the very beginning ... Read More
Rating: - a very comprehensive book
This book lives up to it's claims for "the comprehensive guide to building, programming and administering postgresql databases". I'm a MySQL guy, but may have to do a little pgsql to support a third party app, so I was looking for a book that would bring me up to speed.
The quick review is this... I give this book 3 stars, because it's so huge and covers so much territory that, in my opinion, it does a middling job of it. I would have preferred a more focussed book. I think, given it's goal of ... Read More
- Comprehensive introduction to PostgreSQL
- Disappointed with a serious error
