> On Fri, Sep 29, 2006 at 07:27:49PM +0530, km wrote: > > Is there any good benchmark suite for testing postgresql performance? > > I suggest looking at the excellent software provided by OSDL. > > http://www.osdl.org/lab_activities/kernel_testing/osdl_database_test_suite/ > ya i have tried the dbt1 (database test 1 - which is what i require) from the ODSL site but couldnt compile as i got the error: cache.c: In function `main': cache.c:134: error: `sname2' undeclared (first use in this function) cache.c:134: error: (Each undeclared identifier is reported only once cache.c:134: error: for each function it appears in.) cache.c:146: error: `dbname2' undeclared (first use in this function) cache.c:150: error: `uname2' undeclared (first use in this function) cache.c:154: error: `auth2' undeclared (first use in this function) cache.c: In function `warm_up_cache': cache.c:421: error: storage size of 'dbc' isn't known cache.c:421: warning: unused variable `dbc' cache.c: In function `usage': cache.c:730: error: `uname2' undeclared (first use in this function) cache.c:730: error: `auth2' undeclared (first use in this function) make[1]: *** [cache.so] Error 1 make[1]: Leaving directory `/root/osdl/dbt1-v2.1/cache' make: *** [cache_exe] Error 2 any ideas how to circumvent the problem? regards, KM --
