PostgreSQL DEFAULTS keyword
PostgreSQL DEFAULTS keyword
|
| Release 9.3 |
   |
Note:This topic was updated for 9.3.1.
As the name indicates, the settings under the DEFAULTS configuration keyword are used by default when you create tables, feature classes, raster datasets, and indexes. If you do not specify a different keyword when data is created in the geodatabase, or if you specify a keyword that is missing some necessary parameters, values from the DEFAULTS keyword are used.
In the PostgreSQL dbtune.sde file, most parameters are included twice—once with the default setting and once as a commented parameter to indicate the proper syntax for tablespace designation. This was done because the syntax for tablespace designation varies depending on the type of object created.
Use only one version of the parameter. In other words, if you want to specify a different tablespace for certain indexes, uncomment that line, provide values where applicable, and comment out or delete the other version of the parameter.
##DEFAULTS
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"
END
