The DEFAULTS keyword in PostgreSQL

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 is 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 and comment out or delete the default parameter.

##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

Related Topics


11/18/2013