Thread: pgbench

pgbench

From
"Orr, Steve"
Date:
Is it possible to run pgbench against a MySQL database? Someone claims to
have done that but since it uses libpq and is PostgreSQL specific I'm
skeptical. Any ideas as to how this claim could be true?

TIA,
Steve Orr

Re: pgbench

From
"Shridhar Daithankar"
Date:
On 27 Sep 2002 at 9:37, Orr, Steve wrote:

> Is it possible to run pgbench against a MySQL database? Someone claims to
> have done that but since it uses libpq and is PostgreSQL specific I'm
> skeptical. Any ideas as to how this claim could be true?

It should be possible. Just the one has to replace connection and query
execution function with relevant functions for mysql..

 Bigger problem is how has you make mysql recognise begin;blah;commit??.;-)

Bye
 Shridhar

--
Cynic, n.:    One who looks through rose-colored glasses with a jaundiced eye.


Re: pgbench

From
Tatsuo Ishii
Date:
pgbench comes with PostgreSQL source code distribution and must be
compiled under PostgreSQL source tree.

I'm not familiar with MacOS but I guess there may be pre-compiled
package. Anyone can help him?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> I have just received my new MacBook (1.83Gz. Duo) and wanted to do
> some benchmark testing of Postgres using your Pgbench, however I ma
> getting errors while compiling.
>
> I could probably fix some of these (define TRUE  & RAND_MAX) I am not
> sure what RAND_MAX  is on other systems and as far as the exit(1)?
> again not sure why.  Any help would be appreciated.
>
>
> here is the output:
>
> macbook:~/Desktop/pgbench-1.1 jeffruss$ make
> gcc -O2 -I/usr/local/pgsql/include   -c -o pgbench.o pgbench.c
> pgbench.c:24:22: error: postgres.h: No such file or directory
> pgbench.c: In function 'getrand':
> pgbench.c:94: error: 'RAND_MAX' undeclared (first use in this function)
> pgbench.c:94: error: (Each undeclared identifier is reported only once
> pgbench.c:94: error: for each function it appears in.)
> pgbench.c: In function 'doOne':
> pgbench.c:131: error: 'TRUE' undeclared (first use in this function)
> pgbench.c:216: warning: incompatible implicit declaration of built-in
> function 'strcpy'
> pgbench.c: In function 'doSelectOnly':
> pgbench.c:267: error: 'TRUE' undeclared (first use in this function)
> pgbench.c: In function 'init':
> pgbench.c:355: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:362: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:370: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:378: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:389: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:397: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:407: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:415: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:420: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:426: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:434: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c: In function 'main':
> pgbench.c:523: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:532: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:537: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:545: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:552: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:557: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:565: warning: assignment makes pointer from integer without
> a cast
> pgbench.c:573: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:588: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:595: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:600: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:609: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:616: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:626: error: 'uint' undeclared (first use in this function)
> pgbench.c:626: error: parse error before 'tv1'
> pgbench.c:637: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:659: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:671: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:688: warning: incompatible implicit declaration of built-in
> function 'exit'
> pgbench.c:695: warning: incompatible implicit declaration of built-in
> function 'exit'
> make: *** [pgbench.o] Error 1