effective_cache_size calculation overflow

Started by Magnus Haganderalmost 12 years ago2 messages
#1Magnus Hagander
magnus@hagander.net

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/

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Magnus Hagander (#1)
Re: effective_cache_size calculation overflow

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers