Обсуждение: effective_cache_size calculation overflow

Поиск

Список

Период

Сортировка

effective_cache_size calculation overflow

От

Magnus Hagander

Дата:

26 января 2014 г., 14:53:34

To test something unrelated, I set my shared_buffers to 7TB on my laptop today (no, unfortunately I don't have that much RAM).

That leads to the startup error:

FATAL: -536870912 is outside the valid range for parameter "effective_cache_size" (-1 .. 2147483647)

So clearly there is an overflow somewhere in the calculation of effective_cache_size, most likely from the fact that it's now dynamically calculated.

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/

Re: effective_cache_size calculation overflow

От

Tom Lane

Дата:

27 января 2014 г., 05:06:56

Magnus Hagander <magnus@hagander.net> writes:
> So clearly there is an overflow somewhere in the calculation of
> effective_cache_size, most likely from the fact that it's now dynamically
> calculated.

Yeah.  Fixed.
        regards, tom lane

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: effective_cache_size calculation overflow

effective_cache_size calculation overflow

Re: effective_cache_size calculation overflow