PostgreSQL Performance Pitfalls
PostgreSQL is a database system that can deliver excellent performance for a wide variety of applications. But it's easy to run into an issue that keeps you from seeing its full potential. There are a few basic PostgreSQL configuration and use misunderstandings that cause most of the early performance issues administrators and developers encounter.
This talk covers the most common performance problems seen in real-world PostgreSQL deployment. It briefly summarizes each and points out the basics of how to avoid them. It's like navigating a minefield: you'll progress though a lot faster if you can start by knowing what the mines look like.
With PostgreSQL 9.0 featuring all new built-in replication and query distribution features, the timing has never been better to consider what a serious jump into using PostgreSQL would look like. Getting the performance related aspects right can be one of the most stressful parts of such a migration, particularly if you're new to the database and its quirks. Follow the suggestions here, and you can build your database to postpone many of these slowdowns until you've already proven your application is a success.