云数据库 GAUSSDB-CREATE TABLESPACE:语法格式

时间:2024-11-02 18:51:57

语法格式

1
2
3
CREATE TABLESPACE tablespace_name
    [ OWNER user_name ] [ RELATIVE ] LOCATION 'directory' [ MAXSIZE 'space_size' ]
    [with_option_clause];

其中普通表空间的with_option_clause为:

1
2
3
WITH ( {filesystem= { 'general'| "general" | general} |
    random_page_cost = { 'value ' | value } |
    seq_page_cost = { 'value ' | value }}[,...])
support.huaweicloud.com/distributed-devg-v2-gaussdb/gaussdb-12-0379.html