7.2 Infinite Cache

Table of Contents Previous Next



2.
Modify the Advanced Server postgresql.conf file, enabling Infinite Cache, and specifying connection and compression settings.
The Infinite Cache configuration file is named edbas-icache, and contains two parameters and their associated values:
The PORT variable specifies the port on which Infinite Cache listens for connections from the server.
The CACHESIZE variable specifies the default cache size (in mega-bytes)
By default, the file is located in the /opt/edb/icache/etc directory. To modify a parameter value, open the edbas-icache file with your editor of choice, and edit the parameter values.
To enable Infinite Cache, you must modify the postgresql.conf file, setting the values of the configuration parameters that control the behavior of Infinite Cache. To modify a parameter, open the postgresql.conf file (located in the data directory, under your Advanced Server installation), and locate the section of the configuration file shown below:
Within the postgresql.conf file, lines that begin with a pound sign (#) are treated as a comment; to edit a given parameter, remove the pound sign and specify a value for the parameter. When you've updated and saved the configuration file, restart the database server for the changes to take effect.
Use the edb_enable_icache parameter to enable or disable Infinite Cache. When edb_enable_icache is set to on, Infinite Cache is enabled; if the parameter is set to off, Infinite Cache is disabled.
If you enable Infinite Cache, you must use the edb-icache_servers parameter to specify a list of cache servers.
Use the edb_icache_servers parameter to specify a list of one or more servers with active edb-icache daemons. Specify a string value that takes the form of a comma-separated list of hostname:port pairs. You may specify a maximum of 128 cache nodes.
edb_icache_compression_level controls the compression level that is applied to each page before storing it in the distributed cache. The parameter must be greater than or equal to 0 or less than or equal to 9
A compression level of 0 disables compression, while a compression level of 9 invokes the maximum amount of compression. By default, this parameter is set to 6
After specifying configuration options, you must start the Infinite Cache service. Before starting the service, ensure that the edb-icache daemons are running on each server specified in edb_icache_servers parameter.
The Infinite Cache service script is named edbas-icache. The service script resides in the /etc/init.d directory. For detailed information about stopping or starting a service on your platform, please see Section 5.


Table of Contents Previous Next