Thread: 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?
Re: Safe to put indexes in tablespaces on raid0 disk?
From
"Nicholson, Brad (Toronto, ON, CA)"
Date:
> -----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 havingthe indexes in place. Can you keep your system down while you rebuild the indexes? Can you limp by while you arerebuilding the indexes? Brad.
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 havingthe indexes in place. Can you keep your system down while you rebuild the indexes? Can you limp by while you arerebuilding the indexes? > > Brad. >