Resource Requirement

7.1.1.1. Shared Memory Requirement

Here is a formula to calculate the shared memory requirement.

      Shared memory requirement (in mega bytes) = 10 + num_init_children * max_pool * 0.02
     

For example if you have num_init_children = 32 (the default) and max_pool = 4 (the default), then you will need 10 + 32 * 4 * 0.02 = 12.6 MB.

If you plan to use in memory query cache (see Section 5.12 for more details) in the shared memory, you will need more RAM for it. See memqcache_total_size and memqcache_max_num_cache for required RAM size.

Note that, however, in Pgpool-II 4.1 or after, even if the in memory query cache is not enabled, it consumes additional 128MB of shared memory, if enable_shared_relcache is enabled (it is enabled by default).

7.1.1.2. Process Memory Requirement

Here is a formula to calculate the process memory requirement.

      Process memory requirement in total (in mega bytes) = num_init_children * 0.16
     

For example if you have num_init_children = 32 (the default), you will need 5.2MB. Please note that this is minimum memory requirement upon Pgpool-II child process starting up. Once the process runs, it will consume more memory depending on the message packet sizes and other factors. It is recommended to measure the amount of memory actually used by the process before starting production use.