PostgreSQL DATA DICTIONARY keyword
PostgreSQL DATA DICTIONARY keyword
|
| Release 9.3 |
   |
Note:This topic was updated for 9.3.1.
You can use the DATA_DICTIONARY parameters to set fill factors for system indexes or to specify locations for system tables. Most geodatabases will 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 using the DATA_DICTIONARY parameters below. You need to alter these parameters in the dbtune.sde file prior to creating your geodatabase since they affect the storage of system tables.
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 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
