Read and write operations Array vs multiple rows in Postgres

Question

If I want to store 10k (sometimes less or more) string values against the same ID multiple times, should I use an array to store those string values or should I insert those string values one by one against the same ID.

Dri372 · Accepted Answer · 2021-06-03 07:33:56Z

4

You can do both but just have a look to this tips extract from the doc

Tip: Arrays are not sets; searching for specific array elements can be a sign of database misdesign. Consider using a separate table with a row for each item that would be an array element. This will be easier to search, and is likely to scale better for a large number of elements.

https://www.postgresql.org/docs/current/arrays.html

So I should prefer to store muliple rows.

edited Jun 3, 2021 at 7:33

user330315

answered Jun 3, 2021 at 7:02

Dri372

1,3315 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Read and write operations Array vs multiple rows in Postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related