X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 86973D98A1 for ; Tue, 27 Sep 2005 02:31:38 -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 28044-04 for ; Tue, 27 Sep 2005 05:31:34 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 7B359D9898 for ; Tue, 27 Sep 2005 02:31:35 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j8R5VYil031585 for ; Tue, 27 Sep 2005 05:31:34 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j8R543YR020695 for pgsql-admin@postgresql.org; Tue, 27 Sep 2005 05:04:03 GMT (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: postgresql cluster on SAN Date: Tue, 27 Sep 2005 00:20:18 -0400 Organization: cbbrowne Computing Inc Lines: 17 Message-ID: <60u0g7jg59.fsf@dba2.int.libertyrms.com> References: <82E74D266CB9B44390D3CCE44A781ED96B500D@POSTOFFICE.cranel.local> <43345E36.1020201@travelamericas.com> <4338BFF3.4090301@perridot.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.17 (Jumbo Shrimp, linux) Cancel-Lock: sha1:CK1uHGblpDtuFsuOnGVrfbMHgjc= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.476 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.344] X-Spam-Level: X-Archive-Number: 200509/296 X-Sequence-Number: 19033 robertngo@perridot.com (Robert Ngo) writes: > How about i have one SAN storage for the slony master node and > another SAN to be share by slave nodes that only do SELECT? That seems like a reasonable sort of idea... > Can Dell|EMC AX100i iscsi san with sata drive serve as storage for > postgresql server, will there be problem in I/O performance? I would imagine that the SAN would provide better I/O performance than having a couple of IDE drives; whether you'll have a "problem in I/O performance" depends heavily on what kind of load the system will experience. -- let name="cbbrowne" and tld="acm.org" in String.concat "@" [name;tld];; http://www3.sympatico.ca/cbbrowne/rdbms.html "Linux is only free if your time has no value." -- Jamie Zawinski