Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2

From: "Olivier Andreotti" <olivier(dot)andreotti(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2
Date: 2006-05-18 09:57:26
Message-ID: d5d40b330605180257w2a0cb2dei53d81cbe0d7405e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 = 510
shared_buffer = 16384
max_prepared_transactions = 510
work_mem = 1024
maintenance_work_mem = 1024
fsync = off
wal_buffers = 32
commit_delay = 500
checkpoint_segments = 10
checkpoint_timeout = 300
checkpoint_warning = 0
effective_cache_size = 165 000
autovaccuum = on
default_transaction_isolation = 'read_committed'

What do you think of my tunning ?

Best regards.

O.A

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Chris Mair 2006-05-18 10:16:13 Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle
Previous Message Markus Schaber 2006-05-18 09:43:05 Re: Lot'sa joins - performance tip-up, please?