From: Rural Hunter <ruralhunter@gmail.com>
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?
Date: Tue, 06 Mar 2012 00:50:00 +0800
Message-ID: <4F54EEB8.7070105@gmail.com> (raw)
In-Reply-To: <EC55DC235432104F8255702A8D7344D92575191A@G9W0741.americas.hpqcorp.net>
References: <4F54BF4F.20308@gmail.com>
<EC55DC235432104F8255702A8D7344D92575191A@G9W0741.americas.hpqcorp.net>
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.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ruralhunter@gmail.com, bnicholson@hp.com
Subject: Re: Safe to put indexes in tablespaces on raid0 disk?
In-Reply-To: <4F54EEB8.7070105@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox