Hacker News Reader

I generally agree. I think one case that it weren't true was LISTEN/NOTIFY https://www.postgresql.org/docs/current/sql-notify.html - the API is actually simple and well tested.

Note that LISTEN/NOTIFY isn't compatible with 2 phase commit though, which can potentially rule out its use in some situations.

and doesn't scale well. Meaning using it can take your Postgres server down way before regular SQL workload would.