X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4A8EBD8420 for ; Tue, 30 Aug 2005 09:37:22 -0300 (ADT) 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 48925-02 for ; Tue, 30 Aug 2005 12:37:17 +0000 (GMT) Received: from pelego.atua.com.br (unknown [200.248.138.60]) by svr1.postgresql.org (Postfix) with ESMTP id 42EA1D806D for ; Tue, 30 Aug 2005 09:37:16 -0300 (ADT) Received: from [10.0.0.171] (unknown [10.0.0.171]) by pelego.atua.com.br (Postfix) with ESMTP id 7381A13F657 for ; Tue, 30 Aug 2005 09:37:17 -0300 (BRT) Message-ID: <431452FD.3090402@atua.com.br> Date: Tue, 30 Aug 2005 09:37:17 -0300 From: Alvaro Nunes Melo User-Agent: Debian Thunderbird 1.0 (X11/20050116) X-Accept-Language: en-us, en MIME-Version: 1.0 To: PostgreSQL - Performance Subject: RAID Configuration Sugestion Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.027 required=5 tests=[AWL=0.027] X-Spam-Level: X-Archive-Number: 200508/511 X-Sequence-Number: 14258 Hello, We are about to install a new PostgreSQL server, and despite of being a very humble configuration compared to the ones we see in the list, it's the biggest one we've got till now. The server is a Dual Xeon 3.0 with 2 GB RAM and two SCSI disks. Our main doubt is what is the best configuration for the disks. We are thinking about use them in a RAID-0 array. Is this the best option? What do you suggest on partitioning? Separate partitions for the OS, data and pg_xlog? We'll have some time to work on performance tests, and if someone is interested we can provide our results. Thanks in advance, Alvaro