The article discusses how to use advisory locks in Postgres using a string as a lock key in Go.
- Advisory locks allow clients to take out specific locks with meanings defined by an application, and they are useful for app coordination.
- Postgres tracks lock IDs as integers internally, but it's common to want to use a string as a lock key rather than an arbitrarily defined integer.
- Go provides a built-in hash package that enables an elegant way to acquire advisory locks by producing a 64-bit output using an FNV hash.
- This approach takes advantage of the full 64-bit key space and avoids hash collisions.
