From: Chris Mair <list@1006.org>
To: pgsql-performance@postgresql.org
Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle
Date: Thu, 18 May 2006 12:16:13 +0200
Message-ID: <1147947373.7943.35.camel@dell.home.lan> (raw)
In-Reply-To: <d5d40b330605180257w2a0cb2dei53d81cbe0d7405e@mail.gmail.com>
References: <d5d40b330605180257w2a0cb2dei53d81cbe0d7405e@mail.gmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: list@1006.org
Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle
In-Reply-To: <1147947373.7943.35.camel@dell.home.lan>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox