1 Introduction

Table of Contents Previous Next


1 Introduction

This guide describes the features of EDB Postgres Advanced Server (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.
The libpq C Library. The libpq C library described in Section 5 is the C application programming interface (API) language for Advanced Server.
The PL Debugger. The PL Debugger described in Section 6 is a graphically oriented debugging tool for PL/pgSQL.
Performance Analysis and Tuning. Section 7 contains the various tools for analyzing and improving application and database server performance.
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 mailto:sales@enterprisedb.com 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 Database Compatibility for Oracle Developer's Guide.
System Catalog Tables. Section 10 contains additional system catalog tables added for Advanced Server specific database objects.
Advanced Server Keywords. Section 11 contains information about the words that Advanced Server recognizes as keywords.

1 Introduction

Table of Contents Previous Next