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.

Default

Default is 4 gigabytes (4GB).

Change history

Categories

Configuration, Planner