The LOGFILE_DEFAULTS keyword in PostgreSQL

The LOGFILE_DEFAULTS keyword contains parameters to specify the storage of ArcSDE log file tables. If custom logfile keywords are not created, the settings in the LOGFILE_DEFAULTS keyword are used to specify storage for log file tables for all connecting users.

Tip:

See Custom configuration keywords for information on creating custom keywords.

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.

##LOGFILE_DEFAULTS
LD_INDEX_ALL       "WITH (FILLFACTOR = 75)"
#LD_INDEX_ALL       "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE <lower_case_name> "
LD_STORAGE         ""
#LD_STORAGE         "TABLESPACE <lower_case_name>"
LF_INDEX_ID        "WITH (FILLFACTOR = 75)"
#LF_INDEX_ID        "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE <lower_case_name> "
LF_INDEX_NAME      "WITH (FILLFACTOR = 75)"
#LF_INDEX_NAME      "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE <lower_case_name> "
LF_STORAGE         ""
#LF_STORAGE         "TABLESPACE <lower_case_name>"
SESSION_INDEX      "WITH (FILLFACTOR = 75)"
#SESSION_INDEX      "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE <lower_case_name> "
SESSION_STORAGE    ""
#SESSION_STORAGE    "TABLESPACE <lower_case_name>"
SESSION_TEMP_TABLE 1

END

If you do not alter the values prior to geodatabase creation, you can use the sdedbtune command to set them after the geodatabase is set up. See Altering the contents of the DBTUNE table after it is created for instructions.