This is a fine basic intro to the topic, but the whole argument is hung on a very sketchy benchmark (as noted by the article itself in a footnote).

Some things that'd help improve the argument:

1. Account for table/row locking in the benchmark: is it a factor or not?

2. Re-run the benchmark with for some of the proposed solutions, e.g. local connection pooling and PgBouncer.