PostgreSQL 9.0 High Performance is a new book from Packt that will teach readers the right techniques to obtain optimal PostgreSQL database performance. Written by Gregory Smith, this book will assist readers to discover various practices to scale successful database installations and to avoid the common pitfalls that can slow the system down.
PostgreSQL is a powerful, open source object-relational database system, which runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant and boasts of sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, nested transactions (savepoints), and online/hot backups.
PostgreSQL 9.0 High Performance provides users with theoretical concepts along with hands-on examples to improve their database performance. Additionally, this book will enable users to monitor and improve their PostgreSQL deployments. Furthermore, users will learn to tweak their operating system for best database performance along with finest customs to handle demanding applications.
Using this book, database administrators will learn several server parameters that impact performance and means to benchmark their whole system from hardware to application. The book will help database administrators to understand the working of the query optimizer and to monitor the database on their server. Database administrators will learn to architect replicated systems using the latest features added to PostgreSQL 9.0.
A clear, step-by-step guide to optimizing and scaling up PostgreSQL database servers, this book is ideal for intermediate and advanced database administrators, who wish to use PostgreSQL or monitor a PostgreSQL installation. The book is out now and available from Packt. To read more about it, please visit: www.packtpub.com/postgresql-9-0-high-performance/book
PostgreSQL 9.0 High Performance
![]() |
Accelerate your PostgreSQL system
For more information, please visit: https://www.packtpub.com/postgresql-9-0-high-performance/book |



