Pro PostgreSQL

While you can run PostgreSQL without a lot of overhead, to get the most benefit from it you need to have full understanding of its feature set and how to tune and configure the system for maximum performance. In this tutorial we’ll take you beyond the basics and give you the information you need to go from just another user to serious PostgreSQL professional.

This tutorial will be broken into two major sections:

Administration Best Practices

• Installation
• Upgrades
• Configuration
• Routine Maintenance
• Replication / High availability

Managing Database Use (and abuse)

• Query Level Optimization
• Advanced Indexing
• Tablespaces
• Partitioning

Whether you’re a DBA or developer, you’ll get plenty of information to incorporate into your day-to-day operations. Data is your company’s most valuable asset, so what could be more valuable than getting the most from your database system.