PostgreSQL Antipatterns: hitting the dictionary with a heavy JOIN
We continue our series of articles dedicated to exploring lesser-known ways to enhance the performance of seemingly simple queries in PostgreSQL: a rare entry will make it halfway through JOIN Sisyphus JOIN arrays harmful JOIN and OR CTE JOIN CTE. Don’t think I dislike JOIN that much… 🙂 But often, without it, the query is significantly more efficient than with it. So today, let’s try […]
