PostgreSQL: Tips and TricksPostgreSQL

[ Thanks to Naheed for this link. ]

"PostgreSQL has become an increasingly viable database platform to serve as storage for applications, from classic corporate database use to the latest web apps. But getting the best performance from it has not been an easy subject to learn. You need just the right combination of rules of thumb to get started, solid monitoring, and maintenance to keep your system running well, suggestions for troubleshooting, and hints for add-on tools to add the features the core database doesn't try to handle on its own.

"In this article we will look at some tips and tricks for high performance of PostgreSQL. The tips and tricks covered in this article might provide the right background trivia to make your use of the database simpler when dealing with the smaller problems."

Complete Story

Related Stories:

• MySQL vs. PostgreSQL, Part 1: Table Organization(Dec 01, 2010)
• Lessons from PostgreSQL's Git transition(Oct 27, 2010)
• PostgreSQL vs. MySQL: How to Select the Right Open-Source Database(Oct 22, 2010)
• Server Configuration Tuning in PostgreSQL(Oct 22, 2010)
• Five Enterprise Features in PostgreSQL 9(Oct 01, 2010)
• PostgreSQL 9.0 arrives with many new features(Oct 01, 2010)