To enable the Local Meta Cache Limit feature, set the pgx_catalog_cache_max_size and pgx_relation_cache_max_size parameters.
Parameter Name | Description |
|---|---|
pgx_catalog_cache_max_size | Specify the maximum amount of memory that the backend process should use as the catalog cache. You can enable catalog cache removal by setting it to 8 KB or more. When it is set to 0 (default value), the catalog cache removal is disabled. |
pgx_relation_cache_max_size | Specify the maximum amount of memory that the backend process should use as the relation cache. You can enable relation cache removal by setting it to 8 KB or more. When it is set to 0 (default value), the relation cache removal is disabled. |
Example
Here is an example postgresql.conf configuration:
pgx_catalog_cache_max_size = 1MB pgx_relation_cache_max_size = 1MB
