Skip to content

Glossary: PostgreSQL Beyond the Basics

effective_cache_size

A planner setting that allocates no memory. It tells the planner how much memory is probably available for caching, so a higher value makes index scans look cheaper.

Where the book teaches it

Related terms

Shared buffersrandom_page_cost