🔗 The hidden cost of PostgreSQL arrays

Starting with arrays in PostgreSQL is as simple as declaring a column as integer[], inserting some values, and then querying it later. However, the allure of using arrays can lead to some hidden costs that might take you by surprise.

In this article, we'll look at various aspects of PostgreSQL arrays, including their behavior, performance implications, and situations where they might not be the best solution. We'll also cover indexing options and the case for using junction tables instead.