Joseph Shraibman <jks(at)selectacast(dot)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.