Re: The results of my PostgreSQL/filesystem performance tests - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: The results of my PostgreSQL/filesystem performance tests
Date
Msg-id 200308300234.h7U2YYf12104@candle.pha.pa.us
Whole thread Raw
In response to Re: The results of my PostgreSQL/filesystem performance tests  ("Balazs Wellisch" <balazs@neusolutions.com>)
List pgsql-performance
Balazs Wellisch wrote:
>
> Bill,
>
> Very interesting results. I'd like to command you on your honesty.
> Having started out with the intentions of proving that FreeBSD is faster
> than Linux only to find that the opposite is true must not have been
> rewarding for you. However, these unexpected results serve only to
> reinforce the integrity of your tests.

Looking at the results, ext2 is out because it isn't crash safe, and I
have heard Reiser uses a lot more CPU to do its work.  It does show
ext3 as slow, which was expected.  Interesting how JFS came out, and XFS
would be interesting.  And, of course, it is multiple backends that
really shows PostgreSQL off, so it could radically affect the results.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: The results of my PostgreSQL/filesystem performance tests
Next
From: Bruce Momjian
Date:
Subject: Re: Hardware recommendations to scale to silly load