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/inde...he.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/s...S-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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Raphael,

First off, you'll want to subscribe to, and migrate this discussion to, the
PGSQL-PERFORMANCE mailing list.

Check out Jan's port of TPC-W on pgFoundry, and OSDL has their DBT-1,2,3
tests.

General industry literature?

Well, you'll want your tool to measure the completion time of various tasks
and compile it.

Is this on 7.4 or 8.0?

--
Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Josh Berkus wrote:
I thought my question was too general to be posted to a specific list, from there
the post to the novice list. But I'll move to the performance list.

Those seem to be test suites not interesting to me as mentioned in my original mail.
I don't want to benchmark postgresql, I want to test our db design's performance.

I hope the -performance list will have more helpful answers...

This is on 7.4.


Raph

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings