Managing performance v16
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