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 33995528A6 for ; Wed, 6 Jul 2005 14:58:47 -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 41475-08 for ; Wed, 6 Jul 2005 17:58:42 +0000 (GMT) Received: from pelego.atua.com.br (unknown [200.248.138.60]) by svr1.postgresql.org (Postfix) with ESMTP id A021952886 for ; Wed, 6 Jul 2005 14:58:41 -0300 (ADT) Received: from [10.0.0.171] (unknown [10.0.0.171]) by pelego.atua.com.br (Postfix) with ESMTP id 71D9313F79F for ; Wed, 6 Jul 2005 14:58:31 -0300 (BRT) Message-ID: <42CC1BC7.7060902@atua.com.br> Date: Wed, 06 Jul 2005 14:58:31 -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: Storing data and indexes in different disks 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.032 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/48 X-Sequence-Number: 13289 Hi, I'm about to recommend a server model to a client, and I've read a in many places (including in this list) that storing indexes in one disk and the rest of the database in other disk might increase the overall performance of the system in about 10%. Making this only by a symbolic link is enough, or there are any futher steps? We were thinking (for costs reasons) in use only 2 SCSI disks, without any level of RAID. Is this enough to achieve performance improvement mentioned above? Best regards, Alvaro