1 Introduction

Table of Contents Previous Next

1 Introduction

This guide describes the features of EnterpriseDB’s EDB Postgres Enterprise, formerly known as EDB Postgres Plus Enterprise Edition. The core of EDB Postgres Enterprise is EnterpriseDB’s database server, EDB Postgres Advanced Server.
Database Administration. Chapter 2 contains the 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.
Enhanced SQL Features. Chapter 3 contains the SQL enhancements provided for an Advanced Server database.
Synonyms described in Section 3.1 provide for easy-to-use abbreviations for the fully qualified path names of tables and views.
Hierarchical queries described in Section 3.2 provide for a logical display of tables related by foreign key constraints.
Extended functions and operators described in Section 3.3 provides for additional functionality of SQL.

Partitioned tables described in Section 3.4 provide for the implementation of table partitioning using the SQL CREATE TABLE statement.
Security. Chapter 4 contains various security features.
SQL/Protect described in Section 4.1 provides protection against SQL injection attacks.

EDB*Wrap described in Section 4.2 provides obfuscation of program source code to prevent unwanted scrutiny.

Virtual Private Database described in Section 4.3 provides fine-grained, row level access.
EDB Resource Manager. Chapter 5 contains information on 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.
Database Utilities. Chapter 6 contains database utility programs and interfaces.
EDB*Loader described in Section 6.1 provides a quick and easy method for loading Advanced Server tables.

EDB*Plus described in Section 6.2 is a command line utility program for running SQL statements.
The libpq C library described in Section 6.3 is the C application programming interface (API) language for Advanced Server.
ECPGPlus described in Section 6.4 is a C precompiler for Advanced Server.
Open Client Library. Chapter 7 provides information about the Open Client Library, an application programming interface for Advanced Server.

The PL Debugger described in Section 7.5 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.

Index Advisor described in Section 8.3 helps to determine the additional indexes needed on tables to improve application performance.

SQL Profiler described in Section 8.4 locates and diagnoses poorly running SQL queries in applications.

Query optimization hints described in Section 8.5 allows you to influence the manner in which the query planner processes SQL statements.

DBMS_PROFILER described in Section 8.6 is a built-in package that can be used to gather performance statistics for PL/pgSQL programs.

Dynamic Runtime Instrumentation Tools Architecture (DRITA) described in Section 8.7 provides the capability to capture and view statistics pertaining to wait events that affect system performance.
Built-In Utility Packages. Chapter 9 contains an extensive set of built-in packages that provide functions to quicken and ease development of PL/pgSQL applications.
Expanded Catalog Views. Chapter 10 contains additional catalog views added to Advanced Server to simplify the querying of database object information.
System Catalog Tables. Chapter 11 contains additional system catalog tables added for Advanced Server specific database objects.
Appendix. Chapter 12 contains various miscellaneous topics such as Advanced Server database limits and keywords.

1 Introduction

Table of Contents Previous Next