Skip site navigation (1) Skip section navigation (2)

Re: Which platfform do you recommend?

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: Which platfform do you recommend?
Date: 2004-10-15 17:30:11
Message-ID: m3k6trj3do.fsf@knuth.knuth.cbbrowne.com (view raw or flat)
Thread:
Lists: pgsql-advocacy
The world rejoiced as ajs(at)crankycanuck(dot)ca (Andrew Sullivan) wrote:
> On Wed, Oct 13, 2004 at 01:38:45AM +0300, Devrim GUNDUZ wrote:
>> 
>> For Linux, ext3 seems better, but under some circumstances ext2 could run 
>> more stable. Check pgsql-perform list archives for more discussions on 
>> filesystems on Linux.
>
> Some time ago, Chris Browne posted some test results he did.  It
> turned out that jfs beat xfs, and that either of them completely
> trounced both reiser and ext3.  In particular, ext3 was just plain
> slow.  We won't consider ext2 because it's too dangerous in case of
> crash.

Minor quibble...

... I didn't consider reiserfs at all, for three reasons:

 1.  We weren't seriously considering considering it because
     for DBMS work, it's pretty experimental even yet

 2.  None of the vendors we were dealing with would offer support
     for it.

 3.  It's consciously optimized for dealing with small files, and
     there are conspicuous reports of it slowing down when dealing
     with large files.  Big DBs --> large files...

Drop mention of reiserfs from that and the rest is certainly a fair
assessment.
-- 
"cbbrowne","@","ntlug.org"
http://www3.sympatico.ca/cbbrowne/nonrdbms.html
Rules of the Evil Overlord #15. "I will never employ any device with a
digital  countdown.   If I  find  that  such  a device  is  absolutely
unavoidable, I  will set it to  activate when the  counter reaches 117
and the hero is just putting his plan into operation."
<http://www.eviloverlord.com/>

In response to

pgsql-advocacy by date

Next:From: Alvaro HerreraDate: 2004-10-15 17:53:52
Subject: Re: Which platfform do you recommend?
Previous:From: Evan RempelDate: 2004-10-15 16:51:37
Subject: Re: Which platfform do you recommend?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group