X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 887CED1B523 for ; Mon, 20 Oct 2003 13:09:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 23886-03 for ; Mon, 20 Oct 2003 10:09:12 -0300 (ADT) Received: from fuji.krosing.net (silmet.estpak.ee [194.126.97.78]) by svr1.postgresql.org (Postfix) with ESMTP id 35231D1B516 for ; Mon, 20 Oct 2003 10:09:08 -0300 (ADT) Received: from fuji.krosing.net (localhost.localdomain [127.0.0.1]) by fuji.krosing.net (8.12.8/8.12.8) with ESMTP id h9KD8vBE005075; Mon, 20 Oct 2003 16:08:57 +0300 Received: (from hannu@localhost) by fuji.krosing.net (8.12.8/8.12.8/Submit) id h9KD8NvR005073; Mon, 20 Oct 2003 16:08:23 +0300 X-Authentication-Warning: fuji.krosing.net: hannu set sender to hannu@tm.ee using -f Subject: Re: PostgreSQL data on a NAS device ? From: Hannu Krosing To: Alexander Priem Cc: Jeff , pgsql-performance@postgresql.org In-Reply-To: <00d301c39705$d0898550$b696a8c0@APR> References: <19692.1066578442@sss.pgh.pa.us> <200310191204.23888.josh@agliodbs.com><006101c396d9$8995a060$b696a8c0@APR> <20031020082030.4b460b25.threshar@torgo.978.org> <00d301c39705$d0898550$b696a8c0@APR> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1066655302.4888.15.camel@fuji.krosing.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Mon, 20 Oct 2003 16:08:23 +0300 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/504 X-Sequence-Number: 4252 Alexander Priem kirjutas E, 20.10.2003 kell 15:29: > Thanks for your reply, Jeff. > > If we are going to use a NAS device for storage, then it will be attached > through a gigabit ethernet connection. Fiber will not be an option, since > that would negate the savings we can make by using an IDE NAS device instead > of SCSI-RAID, fiber's pretty expensive, right? > > Using a NAS device (that is used only by PostgreSQL, so it's dedicated) with > 3Gb of RAM and four 7200 rpm IDE harddisks, connected using a gigabit > ethernet connection to the PostgreSQL server, do you think it will be a > match for a SCSI-RAID config using 4 or 6 15000rpm disks (RAID-10) through a > SCSI-RAID controller having 128mb of writeback cache (battery-backed)? I sincerely don't know. But if NAS is something that involves TCP (like iSCSI) then you should take a look at some network card and TCP/IP stack that offloads the protocol processing to the coprocessor on network card. (or just have some extra processors free to do the protocol processing ) --------------- Hannu