EDB Postgres™ Advanced Server Guide

• Introduction
  • What’s New
  • Limitations
  • Conventions Used in this Guide
  • About the Examples Used in this Guide
    • Sample Database Description
• Enhanced Compatibility Features
  • Enabling Compatibility Features
  • Stored Procedural Language
  • Optimizer Hints
  • Data Dictionary Views
  • dblink_ora
  • Profile Management
  • Built-In Packages
  • Open Client Library
  • Utilities
  • ECPGPlus
  • Table Partitioning
• Database Administration
  • 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
• 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
• EDB Resource Manager
  • Creating and Managing Resource Groups
    • CREATE RESOURCE GROUP
    • ALTER RESOURCE GROUP
    • DROP RESOURCE GROUP
    • Assigning a Process to a Resource Group
    • Removing a Process from a Resource Group
    • Monitoring Processes in Resource Groups
  • CPU Usage Throttling
    • Setting the CPU Rate Limit for a Resource Group
    • Example – Single Process in a Single Group
    • Example – Multiple Processes in a Single Group
    • Example – Multiple Processes in Multiple Groups
  • Dirty Buffer Throttling
    • Setting the Dirty Rate Limit for a Resource Group
    • Example – Single Process in a Single Group
    • Example – Multiple Processes in a Single Group
    • Example – Multiple Processes in Multiple Groups
  • System Catalogs
    • edb_all_resource_groups
    • edb_resource_group
• libpq C Library
  • Using libpq with EDB SPL
  • REFCURSOR Support
  • Array Binding
    • PQBulkStart
    • PQexecBulk
    • PQBulkFinish
    • PQexecBulkPrepared
    • Example Code (Using PQBulkStart, PQexecBulk, PQBulkFinish)
    • Example Code (Using PQexecBulkPrepared)
• Debugger
  • Configuring the Debugger
  • Starting the Debugger
  • The Debugger Window
  • Main Debugger Window
    • The Program Body Panel
    • The Tabs Panel
    • The Stack Tab
  • Debugging a Program
    • Stepping Through the Code
    • Using Breakpoints
    • Setting a Global Breakpoint for In-Context Debugging
    • Exiting the Debugger
• Performance Analysis and Tuning
  • Dynatune
    • edb_dynatune
    • edb_dynatune_profile
  • EDB Wait States
    • edb_wait_states_data
    • edb_wait_states_queries
    • edb_wait_states_sessions
    • edb_wait_states_samples
    • edb_wait_states_purge
• EDB Clone Schema
  • Setup Process
    • Installing Extensions and PL/Perl
    • Setting Configuration Parameters
      • Performance Configuration Parameters
      • Status Logging
    • Installing EDB Clone Schema
    • Creating the Foreign Servers and User Mappings
      • Foreign Server and User Mapping for Local Cloning Functions
      • Foreign Server and User Mapping for Remote Cloning Functions
  • EDB Clone Schema Functions
    • localcopyschema
    • localcopyschema_nb
    • remotecopyschema
    • remotecopyschema_nb
    • process_status_from_log
    • remove_log_file_and_job
• Enhanced SQL and Other Miscellaneous Features
  • COMMENT
  • Output of Function version()
  • Logical Decoding on Standby
• System Catalog Tables
  • edb_dir
  • edb_all_resource_groups
  • edb_policy
  • edb_profile
  • edb_redaction_column
  • edb_redaction_policy
  • edb_resource_group
  • edb_variable
  • pg_synonym
  • product_component_version
• Advanced Server Exceptions
• Advanced Server Keywords
• Conclusion