Postgres Plus Advanced Server Performance Features Guide : Table of Contents

Jump to content

1.1 Typographical Conventions Used in this Guide

2 Infinite Cache

2.1 Configuring the Infinite Cache Server

2.1.1 edb_enable_icache

2.1.2 edb_icache_servers

2.1.3 edb_icache_compression_level

2.2 Controlling the edb-icache Daemons

2.2.1 Command Line Options

2.2.2 edb-icache-tool

2.3 Warming the edb-icache Servers

2.3.1 The edb_icache_warm() Functions

2.3.2 Using the edb_icache_warm Binary

2.4 Retrieving Statistics from Infinite Cache

2.4.1 edb_icache_stats()

2.4.2 edb_icache_server_list

2.4.3 edb_icache_server_enable()

2.4.4 Infinite Cache Log Entries

2.5 Allocating Memory to the Cache Servers

3 Asynchronous Pre-Fetch

3.1 effective_io_concurrency

3.2 edb_prefetch_indexscans

4.1.1 edb_dynatune

4.1.2 edb_dynatune_profile

5 Dynamic Runtime Instrumentation Tools Architecture (DRITA)

5.1 Initialization Parameters

5.2 Setting up and Using DRITA

5.3 DRITA Functions

5.4 Simulating Statspack AWR Reports

5.5 Performance Tuning Recommendations

5.6 Event Descriptions

5.7 Catalog Views

5.7.1 edb$system_waits

5.7.2 edb$session_waits

5.7.3 edb$session_wait_history

6 Optimizer Hints

6.1 Default Optimization Modes

6.2 Access Method Hints

6.3 Joining Relations Hints

6.4 Global Hints

6.5 Conflicting Hints