Database Administration

This chapter describes the features that aid in the management and administration of Advanced Server databases.

• Configuration Parameters
  • Setting Configuration Parameters
    • Modifying the postgresql.conf File
    • Modifying the pg_hba.conf File
  • Summary of Configuration Parameters
  • Configuration Parameters by Functionality
    • Top Performance Related Parameters
      • shared_buffers
      • work_mem
      • maintenance_work_mem
      • wal_buffers
      • checkpoint_segments
      • checkpoint_completion_target
      • checkpoint_timeout
      • max_wal_size
      • min_wal_size
      • bgwriter_delay
      • seq_page_cost
      • random_page_cost
      • effective_cache_size
      • synchronous_commit
      • edb_max_spins_per_delay
      • pg_prewarm.autoprewarm
      • pg_prewarm.autoprewarm_interval
    • Resource Usage / Memory
      • edb_dynatune
      • edb_dynatune_profile
    • Resource Usage / EDB Resource Manager
      • edb_max_resource_groups
      • edb_resource_group
    • Query Tuning
      • enable_hints
    • Query Tuning / Planner Method Configuration
      • edb_enable_pruning
    • Reporting and Logging / What to Log
      • trace_hints
      • edb_log_every_bulk_value
    • Auditing Settings
      • edb_audit
      • edb_audit_directory
      • edb_audit_filename
      • edb_audit_rotation_day
      • edb_audit_rotation_size
      • edb_audit_rotation_seconds
      • edb_audit_connect
      • edb_audit_disconnect
      • edb_audit_statement
      • edb_audit_tag
      • edb_audit_destination
      • edb_log_every_bulk_value
    • Client Connection Defaults / Locale and Formatting
      • icu_short_form
    • Client Connection Defaults / Statement Behavior
      • default_heap_fillfactor
      • edb_data_redaction
    • Client Connection Defaults / Other Defaults
      • oracle_home
      • odbc_lib_path
    • Compatibility Options
      • edb_redwood_date
      • edb_redwood_greatest_least
      • edb_redwood_raw_names
      • edb_redwood_strings
      • edb_stmt_level_tx
      • db_dialect
      • default_with_rowids
      • optimizer_mode
    • Customized Options
      • custom_variable_classes
      • dbms_alert.max_alerts
      • dbms_pipe.total_message_buffer
      • index_advisor.enabled
      • edb_sql_protect.enabled
      • edb_sql_protect.level
      • edb_sql_protect.max_protected_relations
      • edb_sql_protect.max_protected_roles
      • edb_sql_protect.max_queries_to_save
      • edb_wait_states.directory
      • edb_wait_states.retention_period
      • edb_wait_states.sampling_interval
      • edbldr.empty_csv_field
      • utl_encode.uudecode_redwood
      • utl_file.umask
    • Ungrouped
      • nls_length_semantics
      • query_rewrite_enabled
      • query_rewrite_integrity
      • timed_statistics
• Index Advisor
  • Index Advisor Components
  • Index Advisor Configuration
  • Using Index Advisor
    • Using the pg_advise_index Utility
    • Using Index Advisor at the psql Command Line
  • Reviewing the Index Advisor Recommendations
    • Using the show_index_recommendations() Function
    • Querying the index_advisor_log Table
    • Querying the index_recommendations View
  • Index Advisor Limitations
• SQL Profiler
• pgsnmpd
  • Configuring pgsnmpd
  • Setting the Listener Address
  • Invoking pgsnmpd
  • Viewing pgsnmpd Help
  • Requesting Information from pgsnmpd
• EDB Audit Logging
  • Audit Logging Configuration Parameters
  • Selecting SQL Statements to Audit
    • Data Definition Language and Data Control Language Statements
    • Data Manipulation Language Statements
  • Enabling Audit Logging
  • Audit Log File
  • Using Error Codes to Filter Audit Logs
  • Using Command Tags to Filter Audit Logs
  • Redacting Passwords from Audit Logs
• Unicode Collation Algorithm
  • Basic Unicode Collation Algorithm Concepts
  • International Components for Unicode
    • Locale Collations
    • Collation Attributes
  • Using a Collation