stress testing and performance monitoring
От | Raphael Bauduin |
---|---|
Тема | stress testing and performance monitoring |
Дата | |
Msg-id | 411B73D8.90906@be.easynet.net обсуждение исходный текст |
Ответы |
Re: stress testing and performance monitoring
|
Список | 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
В списке pgsql-novice по дате отправления: