Postgres Pro
Downloads
Home   >   mailing lists

effective_cache_size calculation overflow - Mailing list pgsql-hackers

From Magnus Hagander
Subject effective_cache_size calculation overflow
Date
Msg-id CABUevEzHZXDWdbBuJC7vG9GqGJw3dgyxz0ETD3=CVCBFcCPHdA@mail.gmail.com
Whole thread Raw
Responses Re: effective_cache_size calculation overflow  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view
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/

pgsql-hackers by date:

Previous
From: Florian Pflug
Date:
Subject: Re: INTERVAL overflow detection is terribly broken
Next
From: Florian Pflug
Date:
Subject: Re: plpgsql.warn_shadow