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 31BDF32A611 for ; Tue, 12 Oct 2004 21:30:30 +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 12497-01 for ; Tue, 12 Oct 2004 20:30:27 +0000 (GMT) Received: from davinci.ethosmedia.com (server226.ethosmedia.com [209.128.84.226]) by svr1.postgresql.org (Postfix) with ESMTP id AC2C632A526 for ; Tue, 12 Oct 2004 21:30:28 +0100 (BST) Received: from [64.81.245.111] (account josh@agliodbs.com HELO temoku.sf.agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 6495340; Tue, 12 Oct 2004 13:31:52 -0700 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: pgsql-performance@postgresql.org Subject: Re: Which plattform do you recommend I run PostgreSQL for best performance? Date: Tue, 12 Oct 2004 13:32:13 -0700 User-Agent: KMail/1.6.2 Cc: nd02tsk@student.hig.se References: <3388.130.243.14.147.1097595901.squirrel@130.243.14.147> In-Reply-To: <3388.130.243.14.147.1097595901.squirrel@130.243.14.147> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200410121332.13849.josh@agliodbs.com> 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/169 X-Sequence-Number: 8645 Tim, > 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? PostgreSQL runs on a lot more platforms than MySQL; it's not even reasonable to compare some of them, like rtLinux, AIX or Cygwin. The only reasonable comparative testing that's been done seems to indicate that: Linux 2.6 is more efficient than FreeBSD which is more efficient than Linux 2.4 all of which are significantly more efficient than Solaris, and ReiserFS, XFS and JFS *seem* to outperform other Linux journalling FSes. However, as others have said, configuration and hardware will probably make more difference than your choice of OS except in extreme cases. And all of the above is being further tested, particularly the filesystems. -- --Josh Josh Berkus Aglio Database Solutions San Francisco