Received-SPF: pass (google.com: domain of ruralhunter@gmail.com designates
	10.68.129.228 as permitted sender) client-ip=10.68.129.228;
Message-ID: <4F54EEB8.7070105@gmail.com>
Date: Tue, 06 Mar 2012 00:50:00 +0800
From: Rural Hunter <ruralhunter@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1;
	rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2
MIME-Version: 1.0
To: "Nicholson, Brad (Toronto, ON, CA)" <bnicholson@hp.com>
CC: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Safe to put indexes in tablespaces on raid0 disk?
References: <4F54BF4F.20308@gmail.com>
	<EC55DC235432104F8255702A8D7344D92575191A@G9W0741.americas.hpqcorp.net>
In-Reply-To: 
 <EC55DC235432104F8255702A8D7344D92575191A@G9W0741.americas.hpqcorp.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

thanks. temporarily not having the indexes should be fine to me.

于2012年3月5日 23:53:52,Nicholson, Brad (Toronto, ON, CA)写到:
>> -----Original Message-----
>> From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-
>> owner@postgresql.org] On Behalf Of Rural Hunter
>> Sent: Monday, March 05, 2012 8:28 AM
>> To: pgsql-admin@postgresql.org
>> Subject: [ADMIN] Safe to put indexes in tablespaces on raid0 disk?
>>
>> I want to separate my indexes into a tablespace which resides on a raid0 disk
>> for fast r/w access. Is it safe? what I mean is, if the raid0 disk is damaged, is it
>> easy to recover the indexes by just recreating those indexes?
>
> You should be fine doing this from a technical perspective.  Make sure you think about the impact of temporarily not having the indexes in place.  Can you keep your system down while you rebuild the indexes?  Can you limp by while you are rebuilding the indexes?
>
> Brad.
>