Обсуждение: EFFECTIVE_CACHE_SIZE

Поиск
Список
Период
Сортировка

EFFECTIVE_CACHE_SIZE

От
Joseph Shraibman
Дата:
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

От
Tom Lane
Дата:
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