I second the complaint about the user and role design in Postgres. The first time I encountered it, I convinced myself I just didn't understand it well enough

I second the complaint about the user and role design in Postgres. The first time I encountered it, I convinced myself I just didn't understand it well enough yet since it didn't make a lot of sense to me that it works like it does.