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 743F79FA48C for ; Thu, 18 May 2006 06:57:34 -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 98815-09 for ; Thu, 18 May 2006 06:57:28 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.201]) by postgresql.org (Postfix) with ESMTP id 2D6459FA226 for ; Thu, 18 May 2006 06:57:28 -0300 (ADT) Received: by wx-out-0102.google.com with SMTP id s7so35594wxc for ; Thu, 18 May 2006 02:57:27 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=nv0ti/mcDB7gfEmvpDhHGKnJaCj4vdg4Tsxkzu16CmDArXJEZZmJYmXbVV9oTdPFiZT2Foh+tMMgEFBwGxCKaO6xPiV2WzX2jvWR4OvNy9MWTJR4yBdht6KxV3w14m2Cbj0m83RMM+K+JUwHe+SqZ8yAnjZe4z6xVDkL3hvZgAI= Received: by 10.70.77.7 with SMTP id z7mr425407wxa; Thu, 18 May 2006 02:57:26 -0700 (PDT) Received: by 10.70.73.3 with HTTP; Thu, 18 May 2006 02:57:26 -0700 (PDT) Message-ID: Date: Thu, 18 May 2006 11:57:26 +0200 From: "Olivier Andreotti" To: pgsql-performance@postgresql.org Subject: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/377 X-Sequence-Number: 19164 Hello, I'm running a benchmark with theses 3 databases, and the first results are not very good for PostgreSQL. PostgreSQL is 20% less performance than MySQL (InnoDB tables) 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 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. For the tunning of PostgreSQL i use official documentation and theses web sites : http://www.revsys.com/writings/postgresql-performance.html http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html Some important points of my postgresql.conf file : max_connections =3D 510 shared_buffer =3D 16384 max_prepared_transactions =3D 510 work_mem =3D 1024 maintenance_work_mem =3D 1024 fsync =3D off wal_buffers =3D 32 commit_delay =3D 500 checkpoint_segments =3D 10 checkpoint_timeout =3D 300 checkpoint_warning =3D 0 effective_cache_size =3D 165 000 autovaccuum =3D on default_transaction_isolation =3D 'read_committed' What do you think of my tunning ? Best regards. O.A