effective_cache_size

A configuration parameter determinig the planner's assumption about the effective size of the disk cache

effective_cache_size is a configuration parameter determinig the planner's assumption about the effective size of the disk cache that is available to a single query.

effective_cache_size was added in PostgreSQL 7.0.

Default value

The default value for effective_cache_size is: 4 gigabytes (4GB).

Change history

Categories

GUC configuration item, Planner