PostgreSQL 中的 DEFAULTS 关键字

顾名思义,在创建表、要素类、栅格数据集以及索引时,默认情况下使用 DEFAULTS 配置关键字下的设置。如果在地理数据库中创建数据时未指定其他关键字,或者指定的关键字缺少某些必要参数,则将使用 DEFAULTS 关键字中的值。

下方是使用 sdedbtune 命令,从 sde_dbtune 表将 DEFAULTS 参数导出到文本文件时会显示的默认 DEFAULTS 参数。所有未指定值的参数都将使用 PostgreSQL 默认值。有关用于创建索引和表的默认值的信息,请参阅 PostgreSQL 文档。

##DEFAULTS
B_STORAGE                  ""
BLK_INDEX_COMPOSITE        "WITH (FILLFACTOR = 75)"
BLK_STORAGE                ""
A_INDEX_RASTER             "WITH (FILLFACTOR = 75)"
BND_INDEX_ID               "WITH (FILLFACTOR = 75)"
BND_STORAGE                ""
D_INDEX_ALL                "WITH (FILLFACTOR = 75)"
D_INDEX_DELETED_AT         "WITH (FILLFACTOR = 75)"
D_STORAGE                  ""
GEOMETRY_STORAGE           "ST_GEOMETRY"
RAS_INDEX_ID               "WITH (FILLFACTOR = 75)"
RAS_STORAGE                ""
UI_TEXT                    "User Interface text description"
XML_COLUMN_STORAGE         "SDE_XML"
XML_DOC_INDEX              "WITH (FILLFACTOR = 75)"
XML_DOC_STORAGE            ""
XML_DOC_UNCOMPRESSED_TYPE  "BINARY"
XML_IDX_FULLTEXT_UPDATE_METHOD "AUTOMATIC"
XML_IDX_INDEX_DOUBLE       "WITH (FILLFACTOR = 75)"
XML_IDX_INDEX_ID           "WITH (FILLFACTOR = 75)"
XML_IDX_INDEX_PK           "WITH (FILLFACTOR = 75)"
XML_IDX_INDEX_STRING       "WITH (FILLFACTOR = 75)"
XML_IDX_INDEX_TAG          "WITH (FILLFACTOR = 75)"
XML_IDX_STORAGE            ""
XML_TS_CONFIG              "pg_catalog.english"
BND_INDEX_COMPOSITE        "WITH (FILLFACTOR = 75)"
A_INDEX_ROWID              "WITH (FILLFACTOR = 75)"
A_INDEX_STATEID            "WITH (FILLFACTOR = 75)"
A_INDEX_USER               "WITH (FILLFACTOR = 75)"
A_INDEX_XML                "WITH (FILLFACTOR = 75)"
A_STORAGE                  ""
AUX_INDEX_COMPOSITE        "WITH (FILLFACTOR = 75)"
AUX_STORAGE                ""
B_INDEX_RASTER             "WITH (FILLFACTOR = 75)"
B_INDEX_ROWID              "WITH (FILLFACTOR = 75)"
B_INDEX_TO_DATE            "WITH (FILLFACTOR = 75)"
B_INDEX_USER               "WITH (FILLFACTOR = 75)"
B_INDEX_XML                "WITH (FILLFACTOR = 75)"
END

如果需要指定与数据库默认值不同的值,可使用 sdedbtune 命令修改参数值并为创建 PostgreSQL 表和索引指定有效的存储值。以下是在 PostgreSQL 中创建表和索引时可指定的某些值的示例:

B_STORAGE              "TABLESPACE userdata"
B_INDEX_ROWID          "WITH (FILLFACTOR = 60)TABLESPACE userdata"
B_INDEX_USER          "WITH (FILLFACTOR = 75)TABLESPACE userdata"
BLK_STORAGE                "TABLESPACE rasterdata"
BLK_INDEX_COMPOSITE        "WITH (FILLFACTOR = 90)USING INDEX TABLESPACE"
A_INDEX_RASTER             "WITH (FILLFACTOR = 75) TABLESPACE rasterdata"
B_INDEX_RASTER             "WITH (FILLFACTOR = 75) TABLESPACE rasterdata"
BND_STORAGE                "TABLESPACE rasterdata"
BND_INDEX_COMPOSITE        "WITH (FILLFACTOR = 90)USING INDEX TABLESPACE"
RAS_STORAGE            "TABLESPACE rasterdata"
RAS_INDEX_ID           "WITH (FILLFACTOR = 90)USING INDEX TABLESPACE rasterdata"

sdedbtune 命令随 ArcSDE 应用程序服务器一同安装。有关修改 sde_dbtune 表中值的说明,请参阅随 ArcSDE 应用程序服务器安装的《ArcSDE 管理命令参考》和修改 DBTUNE 表的内容

相关主题

9/15/2013