PostgreSQL and huge arrays

197 views Asked by At

I have table where I store sample values (1 record per value). Table get's huge (tens of millions of records).

I don't need to filter based on value, just quite frequently add new value and from time to time cleanup old values.

I was wondering about storing samples in one dimensional array instead (so 1 record per "sample type").

Does PG handles well such huge arrays? Is adding new element with array_append will rewrite entire array or just add one element (IO concern)?

Any thoughts?

Thanks!

0

There are 0 answers