Discussed at the time:

PostgreSQL's Imperfections - https://news.ycombinator.com/item?id=22775330 - April 2020 (134 comments)

Other things someone else hated:

Things I Hate About PostgreSQL (2013) - https://news.ycombinator.com/item?id=12467904 - Sept 2016 (114 comments)