PostgreSQL 中的 DEFAULTS 关键字
顾名思义,在创建表、要素类、栅格数据集以及索引时,默认情况下使用 DEFAULTS 配置关键字下的设置。如果在地理数据库中创建数据时未指定其他关键字,或者指定的关键字缺少某些必要参数,则将使用 DEFAULTS 关键字中的值。
大多数参数在 PostgreSQL dbtune.sde 文件中均会出现两次 - 一次按默认设置出现,另一次以作为注释的参数的形式出现,用以为表空间指派指定正确的语法。这么做的原因是表空间指派的语法会因所创建对象的类型而异。
仅使用参数的一个版本。也就是说,如果想为特定索引指定不同的表空间,则请取消注释该行并注释掉或删除默认的参数。
##DEFAULTS RASTER_STORAGE "BINARY" GEOMETRY_STORAGE "ST_GEOMETRY" UI_TEXT "User Interface text for DEFAULTS" A_INDEX_ROWID "WITH (FILLFACTOR = 75)" #A_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE <lower_case_name>" A_INDEX_STATEID "WITH (FILLFACTOR = 75)" #A_INDEX_STATEID "WITH (FILLFACTOR = 75) TABLESPACE <lower_case_name>" A_INDEX_USER "WITH (FILLFACTOR = 75)" #A_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE <lower_case_name>" A_INDEX_XML "WITH (FILLFACTOR = 75)" #A_INDEX_XML "WITH (FILLFACTOR = 75) TABLESPACE <lower_case_name>" A_INDEX_RASTER "WITH (FILLFACTOR = 75)" #A_INDEX_RASTER "WITH (FILLFACTOR = 75) TABLESPACE <lower_case_name>" A_STORAGE "" #A_STORAGE "TABLESPACE <lower_case_name>" B_INDEX_ROWID "WITH (FILLFACTOR = 75)" #B_INDEX_ROWID "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>" B_INDEX_USER "WITH (FILLFACTOR = 75)" #B_INDEX_USER "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>" B_INDEX_XML "WITH (FILLFACTOR = 75)" #B_INDEX_XML "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>" B_INDEX_RASTER "WITH (FILLFACTOR = 75)" #B_INDEX_RASTER "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>" B_INDEX_TO_DATE "WITH (FILLFACTOR = 75)" #B_INDEX_TO_DATE "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>" B_STORAGE "" #B_STORAGE "TABLESPACE <lower_case_name>" D_INDEX_ALL "WITH (FILLFACTOR = 75)" #D_INDEX_ALL "WITH (FILLFACTOR = 75)USING INDEX TABLESPACE <lower_case_name>" D_INDEX_DELETED_AT "WITH (FILLFACTOR = 75)" #D_INDEX_DELETED_AT "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>" D_STORAGE "" #D_STORAGE "TABLESPACE <lower_case_name>" RAS_STORAGE "" #RAS_STORAGE "TABLESPACE <lower_case_name>" RAS_INDEX_ID "WITH (FILLFACTOR = 90)" #RAS_INDEX_ID "WITH (FILLFACTOR = 90)USING INDEX TABLESPACE <lower_case_name>" BND_STORAGE "" #BND_STORAGE "TABLESPACE <lower_case_name>" BND_INDEX_ID "WITH (FILLFACTOR = 90)" #BND_INDEX_ID "WITH (FILLFACTOR = 90)USING INDEX TABLESPACE <lower_case_name>" BND_INDEX_COMPOSITE "WITH (FILLFACTOR = 90)" #BND_INDEX_COMPOSITE "WITH (FILLFACTOR = 90)USING INDEX TABLESPACE <lower_case_name>" AUX_STORAGE "" #AUX_STORAGE "TABLESPACE <lower_case_name>" AUX_INDEX_COMPOSITE "WITH (FILLFACTOR = 75)" #AUX_INDEX_COMPOSITE "WITH (FILLFACTOR = 90)USING INDEX TABLESPACE <lower_case_name>" BLK_STORAGE "" #BLK_STORAGE "TABLESPACE <lower_case_name>" BLK_INDEX_COMPOSITE "WITH (FILLFACTOR = 90)" #BLK_INDEX_COMPOSITE "WITH (FILLFACTOR = 90)USING INDEX TABLESPACE <lower_case_name>" XML_DOC_INDEX "WITH (FILLFACTOR = 75)" #XML_DOC_INDEX "WITH (FILLFACTOR = 75)USING INDEX TABLESPACE <lower_case_name>" XML_DOC_STORAGE "" #XML_DOC_STORAGE "TABLESPACE <lower_case_name>" XML_DOC_UNCOMPRESSED_TYPE "BINARY" XML_IDX_INDEX_DOUBLE "WITH (FILLFACTOR = 75)" #XML_IDX_INDEX_DOUBLE "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>" XML_IDX_INDEX_ID "WITH (FILLFACTOR = 75)" #XML_IDX_INDEX_ID "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>" XML_IDX_INDEX_PK "WITH (FILLFACTOR = 75)" #XML_IDX_INDEX_PK "WITH (FILLFACTOR = 75)USING INDEX TABLESPACE <lower_case_name>" XML_IDX_INDEX_STRING "WITH (FILLFACTOR = 75)" #XML_IDX_INDEX_STRING "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>" XML_IDX_INDEX_TAG "WITH (FILLFACTOR = 75)" #XML_IDX_INDEX_TAG "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>" XML_IDX_STORAGE "" #XML_IDX_STORAGE "TABLESPACE <lower_case_name>" XML_IDX_FULLTEXT_UPDATE_METHOD "AUTOMATIC" XMLCOLUMN_STORAGE "SDE_XML" END
相关主题
7/10/2012