File	Date	Author	Commit
appServer	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
cache	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
common	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
datagen	2010-05-17	Michael P	[e8423a] DBT-1 update due to the coming release of Postg...
dbdriver	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
doc	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
include	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
interfaces	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
scripts	2010-05-17	Michael P	[5343ab] Creation of a new SQL file to upload data direc...
tools	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
wgen	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
wrapper	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
ChangeLog	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
LICENSE	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
Makefile.in	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
README	2010-04-01	Michael P	[47cc46] Addition of a README file for user reference
RELEASE_NOTES	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
TODO	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
appServerList.data.sample	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
configure.in	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
init.sh	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
make.common.in	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
pgxc_stats_param.data.sample	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
pgxc_test_launcher.sh.in	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...
reinstall_pgxc.sh	2010-04-01	Michael P	[5d75e4] Modified DBT-1 as a benchmark test for Postgres...

Read Me

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