dbu

@gromnan i wont run the tests myself now, but at least storage wise postgres arrays seem more efgicient than a json column with an array https://stackoverflow.com/questions/49592794/postgres-are-there-downsides-to-using-a-json-column-vs-an-integer-column

The performance remains unclear from the answer i found...

Postgres: Are There Downsides to Using a JSON Column vs. an integer[] Column?

TLDR: If I want to save arrays of integers in a Postgres table, are there any pros or cons to using an array column (integer[]) vs. using a JSON column (eg. does one perform better than the other)?

Stack Overflow
Mar 25 at 10:20pmWeb