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.

TipTip:

See Custom configuration keywords for information on creating custom keywords.

The following are the default log file 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.

##LOGFILE_DEFAULTS
SESSION_TEMP_TABLE   1.000000
SESSION_STORAGE    ""
SESSION_INDEX      "WITH (FILLFACTOR = 75)"
LF_STORAGE         ""
LF_INDEX_NAME      "WITH (FILLFACTOR = 75)"
LF_INDEX_ID        "WITH (FILLFACTOR = 75)"
LD_STORAGE         ""
LD_INDEX_ALL       "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 values that could be specified for log file table and index creation in PostgreSQL:

SESSION_STORAGE    "TABLESPACE mylogtblspace"
SESSION_INDEX      "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE mylogtblspace "
LF_STORAGE         "TABLESPACE mylogtblspace"
LF_INDEX_NAME      "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE mylogtblspace "
LF_INDEX_ID        "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE mylogtblspace "
LD_STORAGE         "TABLESPACE mylogtblspace"
LD_INDEX_ALL       "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE mylogtblspace "

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

11/6/2014