RE: PostgreSQL: YMMV?

Jan,

I took your test and ran it on my machine.

1GHz PIII 512MB ram, 40GB IDE UDMA 100, RH 2.4.5 kernel postgres 7.1.2
straight from rpm. Jdbc built from cvs, jdk 1.3 from sun
and here are my results

Insert Select Total Max Insert Max Select Max Start
1) 279.639 8.3466 781.31 4408 603
1938
2) 253.918 10.0325 703.88 1853 766
1854

1) with transactions
2) without transactions

Looks better, but I would still like to see improvement.

Dave

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Jan Ploski
Sent: June 25, 2001 4:38 PM
To: Dave Cramer
Cc: pgsql-general(at)postgresql(dot)org
Subject: RE: [GENERAL] PostgreSQL: YMMV?

On Mon, Jun 25, 2001 at 04:06:32PM -0400, Dave Cramer wrote:
> Jan,
>
> I'd be interested in your code. This could be a JDBC driver problem.
>
>
> Cheers,
> Dave

Ok, have a look at http://remotejava.dyndns.org/dbbench

The "total times" in seconds seem off, so just ignore these (the real
execution times in times.log are ok though; each test run takes about
half an hour here).

Also, I will be re-running the tests tonight. In the current code,
all readers finish before the writers do, I am going to change it
so that writers and readers are hitting the database during the whole
run.

Thanks,
JPL

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html