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: 7.3 vs 7.4 performance
Date: Thu, 05 Feb 2004 08:30:55 -0500
Message-ID: <m34qu5mz5c.fsf@wolfe.cbbrowne.com> (raw)
References: <1075958197.2438.330.camel@orthanc>
	<m3smhqm6qv.fsf@wolfe.cbbrowne.com>
	<003c01c3ebd9$35c724e0$cf00a8c0@smanote>

In an attempt to throw the authorities off his trail, csmanioto@uol.com.br ("Carlos Eduardo Smanioto") transmitted:
>> I did some heavy-transaction-oriented tests recently on somewhat
>> heftier quad-Xeon hardware, and found little difference between 2.4
>> and 2.6, and a small-but-quite-repeatable advantage with FreeBSD
>> 4.9.  Now, I'm quite sure my load was rather different from yours,
>> but I find the claim of doubling of speed rather surprising.
>
> What's the type of File System you used in the Linux? I am wanting
> to know which is the operational system better for PostgreSQL:
> FreeBSD versus Linux 2.6.

On the Linux box in question, I was using JFS, which has had the mixed
reviews, lately, that on the one hand, it _appears_ to be a tad faster
than all the others, but that has been, on the other hand, associated
with systems hanging up and crashing, under load.

The latter bit is a _really_ big caveat.  On that particular machine,
I have a nicely repeatable "test case" where I can do a particular set
of "system load" that consistently takes the system down, to the point
of having to hit the "big red button."  If I could point to a clear
reason why it happens, I'd be a much happier camper.  As it stands, it
is a bit nebulous whether the problem is:
 a) Hardware drivers,
 b) Flakey hardware (which Linux 2.6.1 copes with a lot better than
    2.4!),
 c) Flakey 2.4 kernel,
 d) Problem with JFS,
 e) Something else not yet identified as a plausible cause.

If I could say, "Oh, it's an identified bug in the Frobozz RAID
controller drivers, and was fixed in 2.6.0-pre-17", that would help
allay the suspicion that the problem could be any of the above.
-- 
let name="aa454" and tld="freenet.carleton.ca" in name ^ "@" ^ tld;;
http://www.ntlug.org/~cbbrowne/
"Another result of the tyranny of Pascal is that beginners don't use
function pointers."  --Rob Pike



view thread (16+ messages)  latest in thread

Message-ID: <m34qu5mz5c.fsf@wolfe.cbbrowne.com>
Permalink:  ../m34qu5mz5c.fsf@wolfe.cbbrowne.com/
Also on:    postgresql.org/message-id/m34qu5mz5c.fsf@wolfe.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: 7.3 vs 7.4 performance
  In-Reply-To: <m34qu5mz5c.fsf@wolfe.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