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 38F80D9564 for ; Tue, 27 Sep 2005 00:47:40 -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 95334-09 for ; Tue, 27 Sep 2005 03:47:36 +0000 (GMT) Received: from ns2.perridot.com (unknown [202.71.97.144]) by svr1.postgresql.org (Postfix) with ESMTP id A7544D8D96 for ; Tue, 27 Sep 2005 00:47:30 -0300 (ADT) Received: (qmail 1185 invoked by uid 503); 27 Sep 2005 03:47:31 -0000 Received: from 218.208.192.164 by ns2.perridot.com (envelope-from , uid 108) with qmail-scanner-1.24-st-qms (iscan: v3.1/v7.000-1011/723/104409. spamassassin: 3.0.2. perlscan: 1.24-st-qms. Clear:RC:0(218.208.192.164):. Processed in 0.275895 secs); 27 Sep 2005 03:47:31 -0000 Received: from unknown (HELO ?10.35.3.125?) (robertngo@perridot.com@218.208.192.164) by ns.taann.com.my with SMTP; 27 Sep 2005 03:47:31 -0000 Message-ID: <4338BFF3.4090301@perridot.com> Date: Tue, 27 Sep 2005 11:43:47 +0800 From: Robert Ngo User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: postgresql cluster on SAN References: <82E74D266CB9B44390D3CCE44A781ED96B500D@POSTOFFICE.cranel.local> <43345E36.1020201@travelamericas.com> In-Reply-To: <43345E36.1020201@travelamericas.com> 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=1.026 required=5 tests=[RCVD_IN_NJABL_PROXY=1.026] X-Spam-Level: * X-Archive-Number: 200509/295 X-Sequence-Number: 19032 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? Can Dell|EMC AX100i iscsi san with sata drive serve as storage for postgresql server, will there be problem in I/O performance? Chris Travers wrote: > Spiegelberg, Greg wrote: > >> This is possible. Below is a brief recipe. >> >> 1. Use Veritas Storage Foundation HA with Cluster File System. >> 2. Have a volume with cfs available to 2 or more systems via SAN. >> 3. Install PostgreSQL and be sure PGDATA is on the cfs mount >> 4. Create a Storage Checkpoint of cfs mount (read-write virtual copy) >> 5. Bring up PostgreSQL on node1 >> 6. Mount storage checkpoint on node2 >> 7. Start PostgreSQL on node2 >> >> Drawbacks? Heck yes. There are many and you should understand the >> nature of Veritas Storage Checkpoints before using. >> > Drawback #1-- only works read-only on all but one node. And I am not > even sure what will happen when you start writing on that one node... > >> I have tested it >> though in conjunction with dblink() and some other proprietary API's we >> use for load balancing and the potential is there to manage many large >> SELECT's. >> >> > Ok, but what happens when you start doing inserts, updates, and deletes. > > Somehow I think that PostgreSQL's dependance on shmem and semaphores > will cause corruption in your database as soon as you start writing to > it on both nodes. And I don't know enough about PostgreSQL's internal > structure to know if writing on only one node is safe. > > Best Wishes, > Chris Travers > Metatron Technology Consulting > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > >