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 DB2ED3A1A65 for ; Fri, 14 Jan 2005 15:51:58 +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 80995-08 for ; Fri, 14 Jan 2005 15:51:46 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.199]) by svr1.postgresql.org (Postfix) with ESMTP id 102203A1A20 for ; Fri, 14 Jan 2005 15:51:49 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 71so214673wra for ; Fri, 14 Jan 2005 07:51:50 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=b+ucK/21FsHCbRtM9j2OGy4nm1HKFjbl7MXNHxQsPmiZnkW9uDbkIvMlwDD3dkpUsd2Egb+VeC5cLMsGhzfV5VvMpkVS39fgZ4pF5TPEr1Ph1KKlY+u7EPhj9Rt1WJwd5pYEklkAh76P3tPhTOMm8G6oeZTiLkfzjIL4gfiSfAg= Received: by 10.54.41.12 with SMTP id o12mr29633wro; Fri, 14 Jan 2005 07:51:50 -0800 (PST) Received: by 10.54.18.72 with HTTP; Fri, 14 Jan 2005 07:51:50 -0800 (PST) Message-ID: <33c6269f050114075179a035cf@mail.gmail.com> Date: Fri, 14 Jan 2005 10:51:50 -0500 From: Alex Turner Reply-To: alex@neteconomist.com To: Pete de Zwart Subject: Re: Best filesystem for PostgreSQL Database Cluster under Linux Cc: pgsql-performance@postgresql.org In-Reply-To: <41e4364a$0$96874$c30e37c6@ken-reader.news.telstra.net> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <41e39b04$0$96857$c30e37c6@ken-reader.news.telstra.net> <41e4364a$0$96874$c30e37c6@ken-reader.news.telstra.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/186 X-Sequence-Number: 9876 On Wed, 12 Jan 2005 07:25:43 +1100, Pete de Zwart wrote: [snip] > improvement on I/O compared to the improvement potential of moving to > SCSI/FCAL, that and getting more memory. > I would like to ask the question that continues to loom large over all DBAs. SCSI, FCAL and SATA, which works best. Most FCAL loops have a speed limit of either 1Gbps or 2Gbps. This is only 100MB/sec or 200MB/sec. U320 SCSI can handle 320MB/sec and the AMCC (formerly 3Ware) SATA Raid cards show throughput over 400MB/sec with good IOs/sec on PCI-X. I am not prepared to stand by whilst someone makes a sideways claim that SCSI or FCAL is implicitly going to give better performance than anything else. It will depend on your data set, and how you configure your drives, and how good your controller is. We have a Compaq Smart Array controler with a 3 drive RAID 5 than can't break 10MB/sec write on a Bonnie++ benchmark. This is virtualy the slowest system in our datacenter, but has a modern controler and 10k disks, whilst our PATA systems manage much better throughput. (Yes I know that MB/sec is not the only speed measure, it also does badly on IO/sec). Alex Turner NetEconomist