Re: mysql-pgsql comparison

On Sun, 13 Jan 2002, Tom Lane wrote:

> > 3. Check out the OSDB benchmark more closely.
>
> I've been planning to take a hard look at that myself, but haven't found
> the time.  If it's reasonably easy to install and run, it probably ought
> to become our standard benchmarking tool.  (For anyone who wants to
> take a look, OSDB lives at osdb.sourceforge.net.)

I tried it with  current CVS and make test fails (didn't tried
to find what's the problem). Also, you have to edit configure script -
it tries to find postgres_fe.h in include directory, which now lives under
include/internal directory.

Error in test load() at (14252)osdb-pg.c:314:
... cmd
PQresultStatus: 7
postgres reports: ERROR:  copy: line 740, value too long for type character varying(80)
OSDB_ERROR: ERR_DML, (null)
***** osdb-pg-emb *****


Error in test Counting tuples at (14285)../../osdb.c:280:
... empty database -- empty results
perror() reports: No child processes
OSDB_ERROR.error: 0***** osdb-pg-ui *****


Error in test Counting tuples at (14323)../../osdb.c:280:
... empty database -- empty results
perror() reports: Resource temporarily unavailable
make[1]: Leaving directory /db1/u/megera/app/pgsql/bench/osdb/cvs/osdb'


>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
Regards,    Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83