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.
described in Section 3.1
provide for easy-to-use abbreviations for the fully qualified path names of tables and views.
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
Chapter 4 contains various security features.
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.
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.
Dirty Buffer Throttling
described in Section 5.3
provides a method to control the dirty rate of shared buffers by Advanced Server processes.
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.
described in Section 6.4
is a C precompiler for Advanced Server.
|Open Client Library.
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.
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:email@example.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.
contains an extensive set of built-in packages
that provide functions to quicken and ease development of PL/pgSQL applications.
|Expanded Catalog Views.
contains additional catalog views
added to Advanced Server to simplify the querying of database object information.
|System Catalog Tables.
contains additional system catalog tables
added for Advanced Server specific database objects.
contains various miscellaneous topics such as Advanced Server database limits and keywords.