Greenplum管理表空间Tablespace(九)
nces).
Once a filespace is created, it can be used by one or more tablespaces.
20130418:16:40:57:012256 gpfilespace:o564gtser1:gpadmin-[INFO]:-Getting filespace information for TEMPORARY_FILES
20130418:16:40:57:012256 gpfilespace:o564gtser1:gpadmin-[INFO]:-Checking for filespace consistency
20130418:16:40:57:012256 gpfilespace:o564gtser1:gpadmin-[INFO]:-Obtaining current filespace entries used by TEMPORARY_FILES
20130418:16:40:58:012256 gpfilespace:o564gtser1:gpadmin-[INFO]:-TEMPORARY_FILES OIDs are consistent for gtlionsfilespace filespace
20130418:16:40:59:012256 gpfilespace:o564gtser1:gpadmin-[INFO]:-TEMPORARY_FILES entries are consistent for gtlionsfilespace filespace
20130418:16:40:59:012256 gpfilespace:o564gtser1:gpadmin-[INFO]:-Obtaining current filespace entries used by TEMPORARY_FILES
20130418:16:40:59:012256 gpfilespace:o564gtser1:gpadmin-[INFO]:-Current Filespace for TEMPORARY_FILES is gtlionsfilespace
20130418:16:40:59:012256 gpfilespace:o564gtser1:gpadmin-[INFO]:-1 /data1/gtgpseg-1
20130418:16:40:59:012256 gpfilespace:o564gtser1:gpadmin-[INFO]:-2 /data1/gtgpseg0
20130418:16:40:59:012256 gpfilespace:o564gtser1:gpadmin-[INFO]:-3 /data1/gtgpseg1
至此，已经成功的将
系统的默认文件空间pg_system迁移到gtlionsfilespace。
创建一个表空间
gtlions=# create tablespace gtlions_ts1 filespace gtlionsfilespace;
CREATE TABLESPACE
gtlions=# select * from pg_tablespace;
spcname | spcowner | spclocation | spcacl | spcprilocations | spcmirlocations | spcfsoid
-------------+----------+-------------+--------+-----------------+-----------------+----------
pg_default | 10 | | | | | 3052
pg_global | 10 | | | | | 3052
gtlions_ts1 | 98690 | | | | | 98691
(3 rows)
gtlions=# select * from pg_filespace;
fsname | fsowner
------------------+---------
pg_system | 10
gtlionsfilespace | 10
(2 rows)
gtlions=# select * from pg_filespace_entry;
fsefsoid | fsedbid | fselocation
----------+---------+------------------------
3052 | 1 | /data/master/gtgpseg-1
3052 | 2 | /data/primary/gtgpseg0
3052 | 3 | /data/primary/gtgpseg1
98691 | 1 | /data1/gtgpseg-1
98691 | 2 | /data1/gtgpseg0
98691 | 3 | /data1/gtgpseg1
(6 rows)
gtlions=# SELECT spcname, fsname,fsedbid,fselocation FROM pg_tablespace pgts, pg_filespace pgfs,pg_filespace_entry pgfse WHERE pgts.spcfsoid=pgfse.fsefsoid AND pgfse.fsefsoid=pgfs.oid ORDER BY 1,3;
spcname | fsname | fsedbid | fselocation
-------------+------------------+---------+------------------------
gtlions_ts1 | gtlionsfilespace | 1 | /data1/gtgpseg-1
gtlions_ts1 | gtlionsfilespace | 2 | /data1/gtgpseg0
gtlions_ts1 | gtlionsfilespace | 3 | /data1/gtgpseg1
pg_default | pg_system | 1 | /data/master/gtgpseg-1
pg_default | pg_system | 2 | /data/primary/gtgpseg0
pg_default | pg_system | 3 | /data/primary/gtgpseg1
pg_global | pg_system | 1 | /data/master/gtgpseg-1
pg_global | pg_system | 2 | /data/primary/gtgpseg0
pg_global | pg_system | 3 | /data/primary/gtgpseg