1 Introduction

Table of Contents Previous Next


1 Introduction

This guide describes the features of EDB Postgres Advanced Server (Advanced Server).
Enhanced Compatibility Features. Chapter 2 provides an overview of compatibility features supported by Advanced Server.
Database Administration. Chapter 3 contains information about features and tools that are helpful to the database administrator.
Index Advisor described in Section 3.2 helps to determine the additional indexes needed on tables to improve application performance.

SQL Profiler described in Section 3.3 locates and diagnoses poorly running SQL queries in applications.
pgsnmpd described in Section 3.4 is an SNMP agent that returns hierarchical monitoring information regarding the current state of Advanced Server.
Security. Chapter 4 contains information about security features supported by Advanced Server.
SQL/Protect described in Section 4.1 provides protection against SQL injection attacks.

Virtual Private Database described in Section 4.2 provides fine-grained, row level access.
sslutils described in Section 4.3 provides SSL certificate generation functions.
EDB Resource Manager. Chapter 5 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 5.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 5.2 provides a method to control CPU usage by Advanced Server processes.
Dirty Buffer Throttling described in Section 5.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 Chapter 6 is the C application programming interface (API) language for Advanced Server.
The PL Debugger. The PL Debugger described in Chapter 7 is a graphically oriented debugging tool for PL/pgSQL.
Performance Analysis and Tuning. Chapter 8 contains the various tools for analyzing and improving application and database server performance.
Dynatune described in Section 8.1 provides a quick and easy means for configuring Advanced Server depending upon the type of application usage.

Infinite Cache described in Section 8.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.
EDB Clone Schema. Chapter 9 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 described in Chapter 10 is a package providing access to Java stored functions, procedures, and triggers with the JDBC interface.
Enhanced SQL Features. Chapter 11 contains information on enhanced SQL functionality that provides additional flexibility and convenience.
System Catalog Tables. Chapter 12 contains additional system catalog tables added for Advanced Server specific database objects.
Advanced Server Keywords. Chapter 13 contains information about the words that Advanced Server recognizes as keywords.

1 Introduction

Table of Contents Previous Next