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