X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id AB17F9FA293 for ; Thu, 18 May 2006 07:32:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 07848-07 for ; Thu, 18 May 2006 07:32:40 -0300 (ADT) X-Greylist: delayed 00:16:25.209387 by SQLgrey- Received: from 1006.org (unknown [62.146.87.34]) by postgresql.org (Postfix) with ESMTP id 85B9E9F9C18 for ; Thu, 18 May 2006 07:32:41 -0300 (ADT) Received: from dell.home.lan (host45-104.pool875.interbusiness.it [87.5.104.45]) (authenticated (0 bits)) by my.endian.it (8.11.6/8.11.6) with ESMTP id k4IAKZ131285 for ; Thu, 18 May 2006 12:20:35 +0200 Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle From: Chris Mair To: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain Date: Thu, 18 May 2006 12:16:13 +0200 Message-Id: <1147947373.7943.35.camel@dell.home.lan> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-27) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/379 X-Sequence-Number: 19166 Hello :) What version would PostgreSQL 8.1.4 be? > I'm running a benchmark with theses 3 databases, and the first results > are not very good for PostgreSQL. Could you give us some more infos about the box' performance while you run the PG benchmark? A few minutes output of "vmstat 10" maybe? What does "top" say? > My benchmark uses the same server for theses 3 databases : > Dell Power edge - Xeon 2.8 Ghz - 2 Go Ram - 3 SCSI disks - Debian > Sarge - Linux 2.6 How are you using the 3 disks? Did you split pg_xlog and the database on different disks or not? > The transactions are a random mix of request in read (select) and > write (insert, delete, update) on many tables about 100 000 to 15 000 > 000 rows. > > Transactions are executed from 500 connections. Can you say something about the clients? Do they run over network from other hosts? What language/bindings do they use? When they do inserts, are the inserts bundled or are there single insert transactions? Are the statements prepared? Bye, Chris.