X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4EDFAD1D283 for ; Thu, 5 Feb 2004 13:44:50 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 80600-10 for ; Thu, 5 Feb 2004 09:44:56 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 2D64CD1D201 for ; Thu, 5 Feb 2004 09:44:47 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i15Diq1a034328 for ; Thu, 5 Feb 2004 13:44:52 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i15DaW8Z032104 for pgsql-performance@postgresql.org; Thu, 5 Feb 2004 13:36:32 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.performance Subject: Re: 7.3 vs 7.4 performance Date: Thu, 05 Feb 2004 08:30:55 -0500 Organization: cbbrowne Computing Inc Lines: 37 Message-ID: References: <1075958197.2438.330.camel@orthanc> <003c01c3ebd9$35c724e0$cf00a8c0@smanote> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Reasonable Discussion, linux) Cancel-Lock: sha1:DmueHpMbboqT5lm4gvpPjO+lq/c= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/73 X-Sequence-Number: 5597 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