The DATA_DICTIONARY keyword in PostgreSQL

The DATA_DICTIONARY keyword contains parameters that determine the storage settings for specific ArcSDE geodatabase system tables.

You can use the DATA_DICTIONARY parameters to set fill factors for system indexes or to specify locations for system tables. Most geodatabases do not require more than one tablespace for the ArcSDE system tables. However, if you anticipate the need to manage space for these, you can do so by altering the parameters under the DATA_DICTIONARY keyword.

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.

##DATA_DICTIONARY
B_INDEX_ROWID           "WITH (FILLFACTOR = 75)"
#B_INDEX_ROWID           "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE <lower_case_name>"
B_INDEX_USER            "WITH (FILLFACTOR = 75)"
#B_INDEX_USER            "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE <lower_case_name>"
B_STORAGE               ""
#B_STORAGE               "TABLESPACE <lower_case_name>"
MVTABLES_MODIFIED_INDEX "WITH (FILLFACTOR = 75)"
#MVTABLES_MODIFIED_INDEX "WITH (FILLFACTOR = 75)USING INDEX TABLESPACE <lower_case_name>"
MVTABLES_MODIFIED_TABLE ""
#MVTABLES_MODIFIED_TABLE "TABLESPACE <lower_case_name>"
STATE_LINEAGES_INDEX    "WITH (FILLFACTOR = 75)" 
#STATE_LINEAGES_INDEX    "WITH (FILLFACTOR = 75)USING INDEX TABLESPACE <lower_case_name>"
STATE_LINEAGES_TABLE    ""
#STATE_LINEAGES_TABLE	"TABLESPACE <lower_case_name>"
STATES_INDEX            "WITH (FILLFACTOR = 75)" 
#STATES_INDEX            "WITH (FILLFACTOR = 75)USING INDEX TABLESPACE <lower_case_name>"
STATES_TABLE            ""
#STATES_TABLE		"TABLESPACE <lower_case_name>"
VERSIONS_INDEX          "WITH (FILLFACTOR = 75)"
#VERSIONS_INDEX          "WITH (FILLFACTOR = 75)USING INDEX TABLESPACE <lower_case_name>"
VERSIONS_TABLE          ""
#VERSIONS_TABLE		"TABLESPACE <lower_case_name>"
XML_INDEX_TAGS_TABLE    ""
#XML_INDEX_TAGS_TABLE    "TABLESPACE <lower_case_name>"
XML_INDEX_TAGS_INDEX    "WITH (FILLFACTOR = 75)"
#XML_INDEX_TAGS_INDEX    "WITH (FILLFACTOR = 75)USING INDEX TABLESPACE <lower_case_name>"

END