Skip site navigation (1) Skip section navigation (2)

Re: Safe to put indexes in tablespaces on raid0 disk?

From: Rural Hunter <ruralhunter(at)gmail(dot)com>
To: "Nicholson, Brad (Toronto, ON, CA)" <bnicholson(at)hp(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Safe to put indexes in tablespaces on raid0 disk?
Date: 2012-03-05 16:50:00
Message-ID: 4F54EEB8.7070105@gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)postgresql(dot)org [mailto:pgsql-admin-
>> owner(at)postgresql(dot)org] On Behalf Of Rural Hunter
>> Sent: Monday, March 05, 2012 8:28 AM
>> To: pgsql-admin(at)postgresql(dot)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.
>



In response to

pgsql-admin by date

Next:From: Piyush LenkaDate: 2012-03-06 06:22:39
Subject: pg_dump : no tables were found.
Previous:From: Nicholson, Brad (Toronto, ON, CA)Date: 2012-03-05 15:53:52
Subject: Re: Safe to put indexes in tablespaces on raid0 disk?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group