EFFECTIVE_CACHE_SIZE
Started by Joseph Shraibmanalmost 23 years ago2 messagesgeneral
What is the effect of EFFECTIVE_CACHE_SIZE? What happens if I set it too low or too high?
Does a higher setting bias the planner more toward seq scans?
Re: EFFECTIVE_CACHE_SIZE
Joseph Shraibman <jks@selectacast.net> writes:
What is the effect of EFFECTIVE_CACHE_SIZE? What happens if I set it too low or too high?
Does a higher setting bias the planner more toward seq scans?
No, it'd bias towards indexscans. IIRC the parameter is only used to
cost indexscans, and a larger value will tend to make indexscans look
cheaper.
regards, tom lane