Question about index on different tablespace and rebuild it

From: Condor <condor(at)stz-bg(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Question about index on different tablespace and rebuild it
Date: 2018-11-05 08:56:57
Message-ID: 816583dfa3eb6ce411cc7c987aabc4c4@stz-bg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

I have a database that use index on different table space (nvme). I read
documentation about table space and understand table space cannot be
treated as an autonomous collection of data files.
My question is: Is this always true ? I mean if I have table .. okay
here is example:

create table t1 ( i integer);
create index t1_i_idx on t1 using btree (i) tablespace nvme;

In this case only the index is on different table space nvme that is not
part of data stored into table, I mean if I drop the index, data stored
in table will still be untouched and not damaged.
So in this case if I lost table space nvme that is stored into different
nvme drive, can I insert new one and rebuild all index files with
reindexdb for example or some other tool like
mysql/mariadb for example myismcheck or something like that, that can
rebuild index files when DB sever is offline ?

Regards,
HS

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2018-11-05 09:23:23 Re: Logical replication hangs up.
Previous Message Tatsuo Ishii 2018-11-05 02:20:36 Re: Code of Conduct plan,Re: Code of Conduct plan,Re: Code of Conduct plan,Re: Code of Conduct plan