Performance check of my database

On Sun, Aug 12, 2007 at 05:40:26PM -0400, Harpreet Dhaliwal wrote:

Hi,

Lately I completed the business logic of my application and all related
database work.

Now i need to check the performance of my database, how much load it can
bear, perfomance to different queries and stored procedures.

Basically i need to do the performance testing of my database and based on
that I need to take a call whether i should go for clustering or not.

Please let me know the best practices in postgres for such an activity.

Best bet is to write something that drives a fake workload though your
complete system; that way you can see exactly how everything in the
system will handle load.
--
Decibel!, aka Jim Nasby decibel@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)