From: | Raphael Bauduin <raphael(dot)bauduin(at)be(dot)easynet(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | stress testing and performance monitoring |
Date: | 2004-08-12 13:42:48 |
Message-ID: | 411B73D8.90906@be.easynet.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I am migrating a database to postgresql, with a data schema change.
I'd need to do some stress testing (on the db design I have, not
a general test a la TPC). I'm just starting to look at this,
and would appreciate any advice on:
- existing tools (I've seen http://ltp.sourceforge.net/dotshowto.php,
http://dbmonster.kernelpanic.pl/index.html,http://jakarta.apache.org/jmeter/
but still need to test them)
- links and docs to read on db stress testing
I guess the most significant measure is the time needed to complete operations
(read, insert, delete), but I guess other measurements are advisable.
I also wonder what I should measure server side. I've read the docs
on pg_stat* (http://www.postgresql.org/docs/7.4/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE)
but I don't know how I should interpret results, and what I should really pay attention to.
I also plan to monitor the postgres server during the test phase an production phase,
but I'm not sure what I should keep an eye on exactly.
I hope my request is not too general, and that someone on this list has done some
stress testing and can give good advices.
Thanks.
Raph
From | Date | Subject | |
---|---|---|---|
Next Message | Pradeepkumar, Pyatalo (IE10) | 2004-08-12 14:47:06 | how to cast localtimestamp to bigint??? |
Previous Message | Herbie | 2004-08-12 12:00:28 | Two silly questions.. |