RE: PostgreSQL: YMMV?
От | Dave Cramer |
---|---|
Тема | RE: PostgreSQL: YMMV? |
Дата | |
Msg-id | 000001c0fdf8$00155a50$0201a8c0@INSPIRON обсуждение исходный текст |
Ответ на | RE: PostgreSQL: YMMV? (Jan Ploski <jpljpl@gmx.de>) |
Ответы |
Re: PostgreSQL: YMMV?
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: