Key Features
Book Description
If you are a database administrator looking for solutions to common PostgreSQL problems, this is the book for you. The book is suitable for people with intermediate and professional expertise.What you will learn
- Detect bottlenecks caused by missing indexes
- Optimize your data structures for optimal memory footprint
- Write better, performanceoptimized stored procedures
- Monitor PostgreSQL in an efficient way and deal with system corruption and filesystem issues
- Detect replicationrelated problems and make replication more failsafe
- Fix missing indexes and problems arising out of transaction locking
- Find slow queries and optimize your system for speed
Who this book is for
If you are a database administrator looking for solutions to common PostgreSQL problems, this is the book for you. The book is suitable for people with intermediate and professional expertise.
Table of Contents
- Installing PostgreSQL
- Creating data structures
- Handling indexes
- Reading data efficiently.
- Getting transactions and locking right
- Writing proper procedures
- Monitoring PostgreSQL
- Fixing backups and replication
- Handling hardware disaster
- A standard approach to troubleshooting
Loading...
Loading...
