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 E65CD32A15F for ; Wed, 20 Oct 2004 14:06:25 +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 08428-10 for ; Wed, 20 Oct 2004 13:06:15 +0000 (GMT) Received: from mail.ebuz.de (web01.ebuz.de [62.146.49.2]) by svr1.postgresql.org (Postfix) with ESMTP id 47F3532A124 for ; Wed, 20 Oct 2004 14:06:17 +0100 (BST) Received: from [217.232.163.185] (helo=nixe) by mail.ebuz.de with asmtp (Exim 3.33 #1) id 1CKGAQ-000Epr-00 for pgsql-performance@postgresql.org; Wed, 20 Oct 2004 15:06:14 +0200 Date: Wed, 20 Oct 2004 15:10:15 +0200 From: Tom Fischer To: pgsql-performance@postgresql.org Subject: OS desicion Message-ID: <20041020151015.766bb00c@nixe> Organization: eBuz Internetdienste GbR X-Mailer: Sylpheed-Claws 0.9.12b (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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/313 X-Sequence-Number: 8789 Hi List, I have a Dual-Xeon 3Ghz System with with GB RAM and an Adaptec 212=DF SCSI RAID with 4 SCA Harddiscs. Our customer wants to have the Machine tuned for best Database performance. Which OS should we used? We are tending between Linux 2.6 or FreeBSD. The Database Size is 5GB and ascending. Most SQL-Queries are Selects, the Tablesizes are beetween 300k and up to 10 MB. I've read the Hardware Performance Guide and the result was to take FreeBSD in the Decision too :) And what is on this Context Switiching Bug i have read in the Archive?=20 Hope you can help me Regards Tom