EDB Postgres Advanced Server Guide v10

Advanced Server adds extended functionality to the open-source PostgreSQL database. The extended functionality supports database administration, enhanced SQL capabilities, database and application security, performance monitoring and analysis, and application development utilities. This guide documents those features that are exclusive to Advanced Server.

  • Enhanced Compatibility Features. This section provides an overview of compatibility features supported by Advanced Server.
  • Database Administration. This section contains information about features and tools that are helpful to the database administrator.
    • Index Advisor helps to determine the additional indexes needed on tables to improve application performance.
    • SQL Profiler locates and diagnoses poorly running SQL queries in applications.
    • pgsnmpd is an SNMP agent that returns hierarchical monitoring information regarding the current state of Advanced Server.
  • EDB Resource Manager. This section contains information about the EDB Resource Manager feature, which provides the capability to control system resource usage by Advanced Server processes.
    • Resource Groups shows how to create and maintain the groups on which resource limits can be defined.
    • CPU Usage Throttling provides a method to control CPU usage by Advanced Server processes.
    • Dirty Buffer Throttling provides a method to control the dirty rate of shared buffers by Advanced Server processes.
  • The libpq C Library. The libpq C library is the C application programming interface (API) language for Advanced Server.
  • The PL Debugger. The PL Debugger is a graphically oriented debugging tool for PL/pgSQL.
  • Performance Analysis and Tuning. This section contains the various tools for analyzing and improving application and database server performance.
    • Dynatune provides a quick and easy means for configuring Advanced Server depending upon the type of application usage.
    • Infinite Cache provides for performance improvement using memory caching. Note: Infinite Cache has been deprecated and may be removed in a future release. Please contact your EnterpriseDB Account Manager or mailto:sales@enterprisedb.com for more information.
  • EDB Clone Schema. This section contains information about the EDB Clone Schema feature, which provides the capability to copy a schema and its database objects within a single database or from one database to another database.
  • PL/Java. PL/Java is a package providing access to Java stored functions, procedures, and triggers with the JDBC interface.
  • Enhanced SQL Features. This section contains information on enhanced SQL functionality and other features that provide additional flexibility and convenience.
  • System Catalog Tables. This section contains additional system catalog tables added for Advanced Server specific database objects.
  • Advanced Server Keywords. This section contains information about the words that Advanced Server recognizes as keywords.

For information about the features that are shared by Advanced Server and PostgreSQL, see the PostgreSQL core documentation, available at:


whats_new conventions examples_used

introduction enhanced_compatibility_features database_administration index_advisor sql_profiler pgsnmpd edb_audit_logging unicode_collation_algorithm edb_resource_manager libpq_c_library debugger performance_analysis_and_tuning edb_clone_schema pl_java enhanced_sql_and_other_misc_features system_catalog_tables advanced_server_keywords conclusion