Does it make sense to prefer jsonb data type over text[] even if I am only planning to store text array?

Question

I am thinking from the perspective that (I believe) jsonb is more efficient and can get indexed more easily.

I would decide this based on the type of queries that will be needed. Some things can't be done with jsonb and some things can't be done with arrays. — user1822, Jan 24 at 6:57

Laurenz Albe · Accepted Answer · 2023-01-23 19:25:37Z

1

There is no advantage in using a JSON type for a plain array, but I guess there is no big disadvantage either. Keep it simple and use text[].

answered Jan 23 at 19:25

Laurenz Albe

47.8k4 gold badges38 silver badges66 bronze badges

For context, I was wondering if jsonb would produce better performance for typical checks, like checking if array contains value, than GIN index.
– Gajus
Jan 23 at 19:43
No, it should be about the same.
– Laurenz Albe
Jan 23 at 20:48

Add a comment |

1 Answer 1