Re: mysql-pgsql comparison

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Michael Meskes <meskes(at)postgresql(dot)org>, PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: mysql-pgsql comparison
Date: 2002-01-13 17:55:28
Message-ID: Pine.GSO.4.33.0201132052450.12710-100000@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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(at)postgresql(dot)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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tony 2002-01-13 18:01:06 Re: compiling pg_check
Previous Message Tom Lane 2002-01-13 17:45:55 Re: compiling pg_check

Browse pgsql-hackers by date

  From Date Subject
Next Message Al Dev 2002-01-13 18:08:57 Commercial: New Book!! PostgreSQL book is released into the market
Previous Message Bruce Momjian 2002-01-13 17:52:31 Re: About pg_upgrade