First off, you'll want to subscribe to, and migrate this discussion to, the
PGSQL-PERFORMANCE mailing list.
> 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,
>/ but still need to test them)
Check out Jan's port of TPC-W on pgFoundry, and OSDL has their DBT-1,2,3
> - links and docs to read on db stress testing
General industry literature?
> 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*
>-STATS-VIEWS-TABLE), but I don't know how I should interpret results, and
> what I should really pay attention to.
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?
Aglio Database Solutions
In response to
pgsql-novice by date
|Next:||From: Skeets||Date: 2004-08-13 00:34:14|
|Subject: PGSQL Crossroads|
|Previous:||From: Edmund Bacon||Date: 2004-08-12 16:58:08|
|Subject: Re: [SQL] how to cast localtimestamp to bigint???|