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
- PostgreSQL 9.4
- default value changed to
4GB
(commit b910d7ea)
- default value changed to
- PostgreSQL 7.0
- added (commit b1577a7c)
References
- PostgreSQL documentation: effective_cache_size
Useful links
- effective_cache_size: A practical example - July 2020 blog article by Cybertec