Oh yeah seems that FETCH_COUNT is special and is not a regular setting.

All normal settings that you can SET can also be set per-DB and per-user: https://www.postgresql.org/docs/current/config-setting.html#...