Managing performance v15

EDB Postgres Advanced Server extends Postgres with features designed to help database administrators manage performance.

Using the dynamic runtime instrumentation tools architecture (DRITA)

How to use Dynamic Runtime Instrumentation Tools Architecture to query catalog views

Using Index Advisor

How to use the Index Advisor utility to help determine the columns to index to improve performance in a given workload

Using dynamic resource tuning

Describes how to use the Dynatune feature to support dynamic tuning of the database server to make the optimal use of available system resources

Evaluating wait states

EDB wait states provides a way to capture wait events and other data for performance diagnosis

Using SQL Profiler

How to use SQL Profiler to find and optimize inefficient SQL code