Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 61EBD9FA572 for ; Fri, 7 Sep 2007 15:22:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 02539-01-7 for ; Fri, 7 Sep 2007 15:21:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 56E8F9FB67B for ; Fri, 7 Sep 2007 15:22:07 -0300 (ADT) Received: from [192.168.1.2] (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l87IM40f029878 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 7 Sep 2007 11:22:05 -0700 Message-ID: <46E196C6.9090301@commandprompt.com> Date: Fri, 07 Sep 2007 11:21:58 -0700 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5.0.13 (X11/20070824) MIME-Version: 1.0 To: Alan Hodgson CC: pgsql-performance@postgresql.org Subject: Re: SAN vs Internal Disks References: <46E18886.7060502@aptalaska.net> <200709071118.42749@hal.simkin.ca> In-Reply-To: <200709071118.42749@hal.simkin.ca> X-Enigmail-Version: 0.94.2.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV 0.91.1/4178/Fri Sep 7 01:54:58 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Fri, 07 Sep 2007 11:22:05 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/134 X-Sequence-Number: 26679 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Alan Hodgson wrote: > On Friday 07 September 2007 10:56, "Bryan Murphy" > wrote: >> Our database server connects to the san via iSCSI over Gig/E using >> jumbo frames. File system is XFS (noatime). >> >> Throughput, however, kinda sucks. I just can't get the kind of >> throughput to it I was hoping to get. > > A single Gig/E couldn't even theoretically do better than 125MB/sec, so > yeah I would expect throughput sucks pretty bad. We have a customer that has a iSCSI SAN that can bond multiple Gig/E connections that provides them with reasonable performance. You should see if yours allows it. Joshua D. Drake > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFG4ZbGATb/zqfZUUQRAhtmAKCh/PsmkL/JOPq4++Aci2/XwDDJ7wCfbwJs 5vBg+TG5xQFKoJMdybpjDWo= =up8R -----END PGP SIGNATURE-----