In PostgreSQL, what are the pros and cons of using a GIN index on a column of type integer[]
to model sets of tags, instead of doing a relation table?
I am trying to design a simple data model with a table called post
where each post can have a set of tags, similarly to Instagram or StackExchange.
It seems that I would be able to search for a post
that contains a set of tags without having to join two tables, but I won't be able to easily get the list of tag strings for one specific post
.