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.

The following are the default DEFAULTS parameters as they would appear if exported to a text file from the sde_dbtune table using the sdedbtune command. Any parameters that don't have values specified will use the PostgreSQL default values. See your PostgreSQL documentation for default values used for index and table creation.

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

If you want to specify values other than the database defaults, you can use the sdedbtune command to alter parameter values and specify storage values valid for PostgreSQL table and index creation. The following are examples of some values that could be specified for table and index creation in 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"

The sdedbtune command is installed with the ArcSDE application server. See the ArcSDE Administration Command Reference installed with the ArcSDE application server and Altering the contents of the DBTUNE table for instructions on altering values in the sde_dbtune table.

Related Topics

8/21/2013