Read the linked article.
This whole website appears to be Claude slop articles about Postgres.
The “art” is repulsive as well.
Build a users table with a primary key and twenty single-column indexes
That’s pretty bad
(I have seen worse in production, and so have you)
but yes, yes I have.
I have a hard time believing acquiring so many locks you don’t need is particularly harmless. Won’t every single one of those introduce a memory fence? Which will then stall out every CPU core on the server.