pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSafe to put indexes in tablespaces on raid0 disk?
3+ messages / 2 participants
[nested] [flat]
* Safe to put indexes in tablespaces on raid0 disk?
@ 2012-03-05 13:27 Rural Hunter <ruralhunter@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Rural Hunter @ 2012-03-05 13:27 UTC (permalink / raw)
To: pgsql-admin
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Safe to put indexes in tablespaces on raid0 disk?
@ 2012-03-05 15:53 Nicholson, Brad (Toronto, ON, CA) <bnicholson@hp.com>
parent: Rural Hunter <ruralhunter@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Nicholson, Brad (Toronto, ON, CA) @ 2012-03-05 15:53 UTC (permalink / raw)
To: Rural Hunter <ruralhunter@gmail.com>; pgsql-admin
> -----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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Safe to put indexes in tablespaces on raid0 disk?
@ 2012-03-05 16:50 Rural Hunter <ruralhunter@gmail.com>
parent: Nicholson, Brad (Toronto, ON, CA) <bnicholson@hp.com>
0 siblings, 0 replies; 3+ messages in thread
From: Rural Hunter @ 2012-03-05 16:50 UTC (permalink / raw)
To: Nicholson, Brad (Toronto, ON, CA) <bnicholson@hp.com>; +Cc: 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@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.
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-03-05 16:50 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-03-05 13:27 Safe to put indexes in tablespaces on raid0 disk? Rural Hunter <ruralhunter@gmail.com>
2012-03-05 15:53 ` Nicholson, Brad (Toronto, ON, CA) <bnicholson@hp.com>
2012-03-05 16:50 ` Rural Hunter <ruralhunter@gmail.com>
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