X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6311332ACB7 for ; Tue, 12 Oct 2004 22:18:54 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28987-05 for ; Tue, 12 Oct 2004 21:18:50 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id EEE64329EEB for ; Tue, 12 Oct 2004 22:18:51 +0100 (BST) 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 i9CLImJ7029941 for ; Tue, 12 Oct 2004 21:18:48 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i9CKo2Bk019231 for pgsql-performance@postgresql.org; Tue, 12 Oct 2004 20:50:02 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Which plattform do you recommend I run PostgreSQL for best performance? Date: Tue, 12 Oct 2004 16:02:53 -0400 Organization: cbbrowne Computing Inc Lines: 44 Message-ID: References: <3388.130.243.14.147.1097595901.squirrel@130.243.14.147> 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 (Security Through Obscurity, linux) Cancel-Lock: sha1:nlmAziT7r6hsj/8FJNbIoHTLWJw= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/170 X-Sequence-Number: 8646 In an attempt to throw the authorities off his trail, nd02tsk@student.hig.se transmitted: > I am doing a comparison between MySQL and PostgreSQL. > > In the MySQL manual it says that MySQL performs best with Linux 2.4 with > ReiserFS on x86. Can anyone official, or in the know, give similar > information regarding PostgreSQL? The fastest I have ever seen PostgreSQL run is on an IBM pSeries 650 system using AIX 5.1 and JFS2. There aren't many Linux systems that are anywhere _near_ as fast as that. There's some indication that FreeBSD 4.9, running the Berkeley FFS filesystem might be the quickest way of utilizing pedestrian IA-32 hardware, although it is _much_ more important to have a system for which you have a competent sysadmin than it is to have some "tweaked-out" OS configuration. In practice, competent people generally prefer to have systems that hum along nicely as opposed to systems that have ben "tweaked out" such that any little change will cause them to cave in. Benchmarks are useful in determining: a) Whether or not it is realistic to attempt a project, and b) Whether or not you have made conspicuous errors in configuring your systems. They are notoriously BAD as predictive tools, as the benchmarks sponsored by vendors get tweaked to make the vendors' products look good, as opposed to being written to be useful for prediction. See if you see anything useful from MySQL in this regard: > Also, any links to benchmarking tests available on the internet > between MySQL and PostgreSQL would be appreciated. Most database vendors have licenses that specifically forbid publishing benchmarks. -- (reverse (concatenate 'string "gro.mca" "@" "enworbbc")) http://www3.sympatico.ca/cbbrowne/oses.html Do you know where your towel is?