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
