PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance

Key FeaturesBook DescriptionWritten in the cookbook style, this book offers learning and techniques through recipes. It contains step-by-step instructions for administrators and developers to manage databases in PostgreSQL. The book is designed in such a way that you can read it chapter by chapter or refer to recipes in no particular order. This book is for Sysadmins, Database Administrators, Architects, Developers, and anyone with an interest in planning for or running live production databases. The book assumes that you are familiar with the basic operation of PostgreSQL.What you will learn - Change parameters in your system and find out how that will affect the rest of your database Summaries to help DBAs with experience of other database systems Monitor your users so that you can see whether they are connected, what they are running, and whether their account has become blocked Identify temporary data and the effect that it has on your system Advanced technical tips and scripts for experienced users Control the automatic database maintenance program Identify and fix bloated tables and indexes How and when to VACUUM your databases
Who this book is for