effective_cache_size
A GUC parameter determinig the planner's assumption about the effective size of the disk cache that is available to a single query
effective_cache_size is a GUC 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.
References
- PostgreSQL documentation: effective_cache_size
Useful links
- effective_cache_size: A practical example - July 2020 blog article by Cybertec