nik=# select max_val from pg_settings where name = 'max_connections'; max_val --------- 262143 (1 row)
-- here is why
Glossed right over that...yeah, quite a few settings seem to have a max_val of "unsigned numeric", I'd be curious whether they all have some non-datatype maximum recognized during runtime that pg_settings is unable to see.