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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Jan Ploski
Sent: June 25, 2001 4:38 PM
To: Dave Cramer
Cc: pgsql-general@postgresql.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