8.2.5 Warming the edb-icache Servers

Table of Contents Previous Next


8 Performance Analysis and Tuning : 8.2 Infinite Cache : 8.2.5 Warming the edb-icache Servers

Use the edb_icache_warm utility to warm the caches from the command line.
Use the edb_icache_warm() function from within edb-psql.
Use the edb_icache_warm() function via scripts to warm the cache.
The edb_icache_warm() function comes in two variations; the first variation warms not only the table, but any indexes associated with the table. If you use the second variation, you must make additional calls to warm any associated indexes.
The first form of the edb_icache_warm() function warms the given table and any associated indexes into the cache. The signature is:
You may specify table_name as a table name, OID, or regclass value.
When you call the first form of edb_icache_warm(), Advanced Server reads each page in the given table, compresses the page (if configured to do so), and then sends the compressed data to an Infinite Cache server. edb_icache_warm() also reads, compresses, and caches each page in each index defined for the given table.
The second form of the edb_icache_warm() function warms the pages that contain the specified range of bytes into the cache. The signature of the second form is:
The edb_icache_warm() function is typically called by a utility program (such as the edb_icache_warm utility) to spread the warming process among multiple processes that operate in parallel.
You can use the edb_icache_warm command-line utility to load the cache servers with specified tables, allowing fast access to relevant data from the cache.
The syntax for edb_icache_warm is:
# edb_icache_warm –d database –t tablename
The only required parameter is tablename. tablename can be specified with or without the -t option. All other parameters are optional; if omitted, default values are inferred from Advanced Server environment variables.
The options for edb_icache_warm are:

8 Performance Analysis and Tuning : 8.2 Infinite Cache : 8.2.5 Warming the edb-icache Servers

Table of Contents Previous Next