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
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 |