[ 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.”