The OP mentioned that SQLServer does lock (but then, it doesn't use SSI - just SI). The recommendation in PG docs to use a combination of SERIALIZABLE and READ

The OP mentioned that SQLServer does lock (but then, it doesn't use SSI - just SI). The recommendation in PG docs to use a combination of SERIALIZABLE and READ ONLY transactions seems like a good one for read-heavy systems.