This guide describes the features of EDB Postgres Advanced Server (Advanced Server).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:
• Database Administration. Section 2 contains information about features related to database administration.Configuration parameters described in Section 2.1 control the basic characteristics and performance of an Advanced Server instance.
Audit logging described in Section 2.2 provides enhanced database auditing capabilities.Unicode Collation Algorithm described in Section 2.3 provides the capability to create a collation specific to your particular needs on a UTF-8 encoded database.
• Security. Section 3 contains information about security features supported by Advanced Server.SQL/Protect described in Section 3.1 provides protection against SQL injection attacks.
Virtual Private Database described in Section 3.2 provides fine-grained, row level access.
• EDB Resource Manager. Section 4 contains information about the EDB Resource Manager feature, which provides the capability to control system resource usage by Advanced Server processes.Resource Groups described in Section 4.1 shows how to create and maintain the groups on which resource limits can be defined and to which Advanced Server processes can be assigned.CPU Usage Throttling described in Section 4.2 provides a method to control CPU usage by Advanced Server processes.Dirty Buffer Throttling described in Section 4.3 provides a method to control the dirty rate of shared buffers by Advanced Server processes.
• Dynatune described in Section 7.1 provides a quick and easy means for configuring Advanced Server depending upon the type of application usage.
Infinite Cache described in Section 7.2 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 for more information.
Index Advisor described in Section 7.3 helps to determine the additional indexes needed on tables to improve application performance.
SQL Profiler described in Section 7.4 locates and diagnoses poorly running SQL queries in applications.
• Compatibility Features. Section 8 provides an introduction to some of the features that provide compatibility with Oracle databasese. For more information about compatibility features, see the .
• For information about the features that are shared by Advanced Server and PostgreSQL, see the PostgreSQL core documentation, available at: