[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



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@xxxxxxxxxxxxxx [mailto:pgsql-admin-
owner@xxxxxxxxxxxxxx] On Behalf Of Rural Hunter
Sent: Monday, March 05, 2012 8:28 AM
To: pgsql-admin@xxxxxxxxxxxxxx
Subject:  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-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

Powered by Linux