Postgres Pro
Downloads
Home   >   mailing lists

Thread: effective_cache_size calculation overflow

effective_cache_size calculation overflow

From
Magnus Hagander
Date:
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

From
Tom Lane
Date:
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