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 05DFD3A202A for ; Fri, 5 Nov 2004 21:00:25 +0000 (GMT) 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 59326-04 for ; Fri, 5 Nov 2004 21:00:15 +0000 (GMT) Received: from vsmtp3.tin.it (vsmtp3alice.tin.it [212.216.176.143]) by svr1.postgresql.org (Postfix) with ESMTP id 35C513A3E7A for ; Fri, 5 Nov 2004 21:00:16 +0000 (GMT) Received: from angus.tin.it (82.51.70.133) by vsmtp3.tin.it (7.0.027) id 4183C0F6002CD462 for pgsql-performance@postgresql.org; Fri, 5 Nov 2004 22:00:17 +0100 Message-Id: <6.1.2.0.2.20041105220007.03401ec0@box.tin.it> X-Sender: angusgb@box.tin.it (Unverified) X-Mailer: QUALCOMM Windows Eudora Version 6.1.2.0 Date: Fri, 05 Nov 2004 22:00:16 +0100 To: "Postgresql Performance" From: Gabriele Bartolini Subject: Question regarding the file system Mime-Version: 1.0 Content-Type: multipart/mixed; x-avg-checked=avg-ok-68BC2236; boundary="=======1C6B1C17=======" 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: 200411/111 X-Sequence-Number: 9065 --=======1C6B1C17======= Content-Type: text/plain; x-avg-checked=avg-ok-68BC2236; charset=us-ascii; format=flowed Content-Transfer-Encoding: 8bit Hi guys, I have been given a dual PIII with 768MB RAM and I am going to install PostgreSQL on it, for data warehousing reasons. I have also been given four 160 Ultra SCSI disks (36MB each) with a RAID controller (Adaptec 2100). I am going to use a RAID5 architecture (this gives me approximately 103 GB of data) and install a Debian Linux on it: this machine will be dedicated exclusively to PostgreSQL. I was wondering which file system you suggest me: ext3 or reiserfs? Also, I was thinking of using the 2.6.x kernel which offers a faster thread support: will PostgreSQL gain anything from it or should I stick with 2.4.x? Thank you very much, -Gabriele -- Gabriele Bartolini: Web Programmer, ht://Dig & IWA/HWG Member, ht://Check maintainer Current Location: Prato, Toscana, Italia angusgb@tin.it | http://www.prato.linux.it/~gbartolini | ICQ#129221447 > "Leave every hope, ye who enter!", Dante Alighieri, Divine Comedy, The Inferno --=======1C6B1C17======= Content-Type: text/plain; charset=us-ascii; x-avg=cert; x-avg-checked=avg-ok-68BC2236 Content-Disposition: inline --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004 --=======1C6B1C17=======--