/dbt1

Benchmark DBT-1, based on TPC-W benchmark

Primary LanguageCOtherNOASSERTION

Modified DBT-1 for Postgres-XC test and evaluation

This folder contains DBT-1 material to test and evaluate Postgres-XC.

The following modifications were made.

1. PostgreSQL interface was changed from ODBC to libpq.   It allows 
   much more workload to apply.

2. Added housekeeping feature of ORDER table.   Original DBT-1 did not 
   maintain old ORDER table.   So performance drop was observed when 
   the benchmark is done for a long period (days to weeks).   The main 
   reason is infinite growth of ORDER table.

3. Table design change.  Table design was changed to utilize Postgres-XC's 
   parallel execution feature and to avoid cross-node operations.   
   For details of the change, please refer to Postgres-XC's architecture 
   document.

The original DBT-1 repository will be found at 

git://osdldbt.git.sourceforge.net/gitroot/osdldbt/osdldbt

And the summary will be at

http://osdldbt.git.sourceforge.net/git/gitweb.cgi?p=osdldbt/dbt1;a=summary

Postgres-XC development team appreciates Mr.Mark Wong who kindly approved 
to add this material to Postgres-XC releases.   We also appreciate if 
anybody take a look at these modifications and include some of them into 
the original DBT-1 repository.

Postgres-XC development team

Command to launch in order to get results easily
./tools/results --mixfile mix.log --outputdir .
Output files are BT and ips.csv.