Discussion:
[ADMIN] Safe to put indexes in tablespaces on raid0 disk?
(too old to reply)
Rural Hunter
2012-03-05 13:27:43 UTC
Permalink
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?
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Rural Hunter
2012-03-05 16:50:00 UTC
Permalink
thanks. temporarily not having the indexes should be fine to me.
-----Original Message-----
Sent: Monday, March 05, 2012 8:28 AM
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.
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Loading...