Isn't tuning before hitting constraints a premature optimisation? The approach of not spending time on tuning settings before you have to seems sane.

And TFA shows you that in this world Postgres is close enough to Redis.