| From: | Decibel! <decibel(at)decibel(dot)org> |
|---|---|
| To: | Harpreet Dhaliwal <harpreet(dot)dhaliwal01(at)gmail(dot)com> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Performance check of my database |
| Date: | 2007-08-15 16:03:43 |
| Message-ID: | 20070815160342.GI54135@nasby.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2007-08-15 16:14:23 | Re: is this trigger safe and efective? - locking (caching via triiggers) |
| Previous Message | Decibel! | 2007-08-15 16:00:27 | Re: Deadlocks caused by a foreign key constraint |