Re: The results of my PostgreSQL/filesystem performance tests

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: The results of my PostgreSQL/filesystem performance tests
Date: 2003-08-28 11:48:07
Message-ID: m3u182gg08.fsf@chvatal.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

A long time ago, in a galaxy far, far away, balazs(at)neusolutions(dot)com ("Balazs Wellisch") wrote:
> 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.

Well put.

To see a result that the tester didn't really want to see/present does
suggest good things about the tester's honesty. There was incentive
to hide unfavorable results.

What it still leaves quite open is just what happens when the OS has
more than one disk drive or CPU to play with. It's not clear what
happens in such cases, whether FreeBSD would catch up, or be "left
further in the dust." The traditional "propaganda" has been that
there are all sorts of reasons to expect PostgreSQL on FreeBSD to run
a bit faster than on Linux; it is a bit unexpected for the opposite to
seem true.
--
output = reverse("gro.mca" "@" "enworbbc")
http://www3.sympatico.ca/cbbrowne/sap.html
"I am aware of the benefits of a micro kernel approach. However, the
fact remains that Linux is here, and GNU isn't --- and people have
been working on Hurd for a lot longer than Linus has been working on
Linux." -- Ted T'so, 1992.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ludek Finstrle 2003-08-28 12:05:05 Re: The results of my PostgreSQL/filesystem performance tests
Previous Message Russell Garrett 2003-08-28 09:28:29 Re: Queries sometimes take 1000 times the normal time