PostgreSQL DBTUNE configuration parameters |
|
Release 9.3 |
NOTE: Tablespaces in PostgreSQL use symbolic links; therefore, user-defined tablespaces can only be used on systems that support symbolic links.
The following table is an alphabetic list of all the possible configuration parameters that can be used in a geodatabase in PostgreSQL. Following that is a more in-depth explanation of the parameters grouped by their functionalityParameter name | Description | Values |
---|---|---|
A_INDEX_ROWID | Adds table object ID column index storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
A_INDEX_STATEID | Adds table sde_state_id column index storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
A_INDEX_USER | Adds table index storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
A_INDEX_XML | Adds table XML column index table storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
A_STORAGE | Adds table storage definition | See the PostgreSQL documentation for CREATE TABLE parameters. |
AUX_INDEX_COMPOSITE | Raster AUX table composite column index storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
AUX_STORAGE | Raster AUX table storage definition | See the PostgreSQL documentation for CREATE TABLE parameters. |
B_INDEX_RASTER | Business table raster column index storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
B_INDEX_ROWID | Business table object ID column index aster rowid index R<N>_SDE_ROWID_UK storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
B_INDEX_TO_DATE | Storage parameter info for creating the index r<registration_id>_sde_todate, which is used when updating the history table during an archive operation | See the PostgreSQL documentation for CREATE INDEX parameters. |
B_INDEX_USER | Business table user index storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
B_INDEX_XML | Business table XML column index table storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
B_STORAGE | Business table and raster attribute table storage definition | See the PostgreSQL documentation for CREATE TABLE parameters. |
BLK_INDEX_COMPOSITE | Raster BLK table composite column index storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
BLK_STORAGE | Raster BLK table storage definition | See the PostgreSQL documentation for CREATE TABLE parameters. |
BND_INDEX_COMPOSITE | Raster BND table composite column index storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
BND_INDEX_ID | Raster BND table rid column index storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
BND_STORAGE | Raster BND table storage definition | See the PostgreSQL documentation for CREATE TABLE parameters. |
COMMENT | Line used for comments | Can place any comment up to 2048 characters |
D_INDEX_ALL | FILLFACTOR for index on sde_states_id, sde_deletes_row_id, and deleted_at columns | See the PostgreSQL documentation for CREATE INDEX parameters. |
D_INDEX_DELETED_AT | Deletes table sde_deleted_at column index storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
D_STORAGE | Deletes table storage definition | See the PostgreSQL documentation for CREATE TABLE parameters. |
GEOMETRY_STORAGE | Indicates storage data type for spatial column | ST_GEOMETRY or PG_GEOMETRY |
LD_INDEX_ALL | Sde_logfile_data and sde_logpool tables' primary key storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
LD_STORAGE | Sde_logfile_data and sde_logpool tables' storage definition | See the PostgreSQL documentation for CREATE TABLE parameters. |
LF_INDEX_ID | Sde_logfile primary key storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
LF_INDEX_NAME | Storage definition for sde_logfiles unique index | See the PostgreSQL documentation for CREATE INDEX parameters. |
LF_STORAGE | Sde_logfiles table storage definition | See the PostgreSQL documentation for CREATE TABLE parameters. |
MVTABLES_MODIFIED_INDEX | Mvtables_modified index storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
MVTABLES_MODIFIED_TABLE | Mvtables_modified table storage definition | See the PostgreSQL documentation for CREATE TABLE parameters. |
RAS_INDEX_ID | Raster RAS table RID index storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
RAS_STORAGE | Raster RAS table storage definition | See the PostgreSQL documentation for CREATE TABLE parameters. |
SESSION_INDEX | ArcSDE session-based and stand-alone log file indexes storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
SESSION_STORAGE | ArcSDE session-based and stand-alone log file tables storage definition | See the PostgreSQL documentation for CREATE TABLE parameters. |
SESSION_TEMP_TABLE | Controls whether or not log files get created in tempdb | 1 or 0 1 = create in tempdb 0 = don't create in tempdb This parameter is present but not currently used in PostgreSQL. |
STATES_INDEX | States table storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
STATES_LINEAGES_INDEX | Controls the storage of the index on the sde_state_lineages table's primary key | See the PostgreSQL documentation for CREATE INDEX parameters. |
STATES_LINEAGES_TABLE | Sde_state_lineages table storage definition | See the PostgreSQL documentation for CREATE TABLE parameters. |
STATES_TABLE | Sde_states table storage definition | See the PostgreSQL documentation for CREATE TABLE parameters. |
UI_NETWORK_TEXT | User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of network configuration | Description up to 2048 characters |
UI_TERRAIN_TEXT | User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of terrain configuration | Description up to 2048 characters |
UI_TEXT | User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of associated noncomposite configuration keyword | Description up to 2048 characters |
UI_TOPOLOGY_TEXT | User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of topoology configuration | Description up to 2048 characters |
VERSIONS_INDEX | Sde_versions index storage definition | See the PostgreSQL documentation for CREATE INDEX parameters. |
VERSIONS_TABLE | Sde_versions table storage definition | See the PostgreSQL documentation for CREATE TABLE parameters. |
XML_DOC_INDEX | Storage clause for xmldoc<n>_pk and xml_doc<n>_ix indexes on the sde_xml_doc<n> table | See the PostgreSQL documentation for CREATE INDEX parameters. |
XML_DOC_STORAGE | Storage clause for sde_xml_doc<n> table | See the PostgreSQL documentation for CREATE TABLE parameters. |
XML_DOC_UNCOMPRESSED_TYPE | Determines the storage format for XML documents | BINARY orTEXT |
XML_IDX_FULLTEXT_UPDATE_METHOD | Dictates how changes made to the xml_doc_val column in the sde_xml_doc<n> table (the XML document table) and the text_tag column of the sde_xml_idx<n> table (the index table of an XML column) are propagated to the full-text index | AUTOMATIC or MANUAL |
XML_IDX_INDEX_DOUBLE | Storage clause for the xmlix<n>_db index on the double_tag column of the sde_xml_idx<n> table | See the PostgreSQL documentation for CREATE INDEX parameters. |
XML_IDX_INDEX_ID | Storage clause for the xmlix<n>_id index on the ID column of the xml_idx<n> table | See the PostgreSQL documentation for CREATE INDEX parameters. |
XML_IDX_INDEX_PK | Storage clause for xmlix<n>_pk index on the xml_key_column identity column of the sde_xml_idx<n> table | See the PostgreSQL documentation for CREATE INDEX parameters. |
XML_IDX_INDEX_STRING | Storage clause for xmlix<n>_st index on the string_tag column of the sde_xml_idx<n> table | See the PostgreSQL documentation for CREATE INDEX parameters. |
XML_IDX_INDEX_TAG | Storage clause for the xmlix<n>_tg index on the tag_id column of the sde_xml_idx<n> table | See the PostgreSQL documentation for CREATE INDEX parameters. |
XML_IDX_STORAGE | Storage clause for sde_xml_idx<n> table (the index table of an XML column) | See the PostgreSQL documentation for CREATE TABLE parameters. |
NOTE: For the XML parameters, <n> refers to the xml_column_id associated with a specific XML column.
NOTE: To use the PG_GEOMETRY storage type, you must have PostGIS installed and the database must be enabled to use the PostGIS geometry storage type. See Using the PostGIS geometry type in the "Geodatabase data storage and schema" section of the help for details.
See The ST_Geometry storage type in the "Geodatabase data storage and schema" section of the help for a description of this data storage type.NOTE: If you do not use XML columns and XML documents in your geodatabase, you don't need to configure these parameters.
XML configuration parameters are used to specify storage information for the tables and indexes used to track and store XML documents. The XML_INDEX_TAGS_INDEX parameter of the DATA_DICTIONARY configuration keyword specifies the fill factor for the indexes on the sde_xml_indexes table. The XML_INDEX_TAGS_TABLE parameters of the DATA_DICTIONARY configuration keyword defines the storage for the sde_xml_index_tags ArcSDE geodatabase system tables. If you want to specify custom storage with these two parameters, you must alter their values before you create your geodatabase since they control storage for geodatabase system tables. The A_INDEX_XML parameter defines the fill factor of the index on the XML column in the adds table of a versioned feature class. The B_INDEX_XML parameter defines the fill factor of the index on the XML column of business tables. XML_IDX_FULLTEXT_UPDATE_METHOD defines how changes made to the xml_doc_val column in the XML document table (sde_xml_doc<n>) and the text_tag column of the index table of an XML column (sde_xml_idx<n>) are propagated to the full-text index. The options for this parameter are AUTOMATIC or MANUAL. When set to AUTOMATIC, a trigger created on the XML side tables updates indexes as rows are inserted. If the value for XML_IDX_FULLTEXT_UPDATE_METHOD is not set to AUTOMATIC, it is assumed to be MANUAL. The XML_DOC_STORAGE parameter sets the storage for the sde_xml_doc<n> table. The XML_DOC_INDEX configuration parameter sets the fill factor for the xmldoc<n>_pk and xml_doc<n>_ix indexes on the sde_xml_doc<n> table. The XML_DOC_UNCOMPRESSED_TYPE configuration parameter determines how the contents of XML documents will be stored. The options are BINARY or TEXT. If you use BINARY, data is stored as bytea data type. If you use TEXT, the data will be either Unicode or ASCII, depending on whether your database is set to store Unicode data (UTF-8) or not. The XML_IDX_STORAGE configuration parameter sets the storage for the sde_xml_idx<n> table, which is the index table of an XML column. The following parameters define storage for indexes on columns in the sde_xml_idx<n> table itself:#COMMENT "This keyword is used by ArcSDE to create log file tables
for all users logged in as editor"