pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: Which plattform do you recommend I run PostgreSQL for best performance?
Date: Tue, 12 Oct 2004 16:02:53 -0400
Message-ID: <m3mzyrn1qq.fsf@knuth.knuth.cbbrowne.com> (raw)
References: <3388.130.243.14.147.1097595901.squirrel@130.243.14.147>

In an attempt to throw the authorities off his trail, nd02tsk@student.hig.se transmitted:
> I am doing a comparison between MySQL and PostgreSQL.
>
> In the MySQL manual it says that MySQL performs best with Linux 2.4 with
> ReiserFS on x86. Can anyone official, or in the know, give similar
> information regarding PostgreSQL?

The fastest I have ever seen PostgreSQL run is on an IBM pSeries 650
system using AIX 5.1 and JFS2.  There aren't many Linux systems that
are anywhere _near_ as fast as that.

There's some indication that FreeBSD 4.9, running the Berkeley FFS
filesystem might be the quickest way of utilizing pedestrian IA-32
hardware, although it is _much_ more important to have a system for
which you have a competent sysadmin than it is to have some
"tweaked-out" OS configuration.

In practice, competent people generally prefer to have systems that
hum along nicely as opposed to systems that have ben "tweaked out"
such that any little change will cause them to cave in.  

Benchmarks are useful in determining:

  a) Whether or not it is realistic to attempt a project, and

  b) Whether or not you have made conspicuous errors in configuring
     your systems.

They are notoriously BAD as predictive tools, as the benchmarks
sponsored by vendors get tweaked to make the vendors' products look
good, as opposed to being written to be useful for prediction.

See if you see anything useful from MySQL in this regard:
<http://www.mysql.com/it-resources/benchmarks/;

> Also, any links to benchmarking tests available on the internet
> between MySQL and PostgreSQL would be appreciated.

Most database vendors have licenses that specifically forbid
publishing benchmarks.
-- 
(reverse (concatenate 'string "gro.mca" "@" "enworbbc"))
http://www3.sympatico.ca/cbbrowne/oses.html
Do you know where your towel is?



view thread (7+ messages)  latest in thread

Message-ID: <m3mzyrn1qq.fsf@knuth.knuth.cbbrowne.com>
Permalink:  ../m3mzyrn1qq.fsf@knuth.knuth.cbbrowne.com/
Also on:    postgresql.org/message-id/m3mzyrn1qq.fsf@knuth.knuth.cbbrowne.com

 · 

reply

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: cbbrowne@acm.org
  Subject: Re: Which plattform do you recommend I run PostgreSQL for best performance?
  In-Reply-To: <m3mzyrn1qq.fsf@knuth.knuth.cbbrowne.com>

* 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