Re: benchmark suite

> 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
--