Nice article, although the part on fuzzy search not being supported by PostgreSQL is partly incorrect. The pg_trgm extension and an GIN trigram index supports the use case of fuzzy search like in the example in this article:

https://www.postgresonline.com/article_pfriendly/169.html

This could wastly speed up query but with added cost of more memory usage and operation time during updates.