Hello, I'm wondering if anyone could point me towards performance/space
tradeoffs for large tables in Postgres. I would like to create a very
large table that has in each tuple a varchar and a list of integers. What
are the benefits of designing my table as a varchar/array of integers
vs. the more standard relational way of having a separate tuple for each
varchar/integer pair?
I assume using the array type would save me some cost on storage, while
using the varchar/integer pairs would result in faster queries. Is this
correct? Thanks for any help or pointers.