Max array size

"Postgres User" <postgres.developer@gmail.com> writes:

Does anyone know the maximum number of elements allowed in a
one-dimensional array? It looks like my script may add at least a
couple million, not sure if it will hit a limit...

You'd hit the 1GB field size limit before you hit anything else,
at least in terms of hard limits. But the *practical* limit is likely
to be a whole lot less, especially if you are talking about a
variable-width datatype. Indexing into such a large array would
perform poorly.

I'd counsel redesigning your data representation. You'll be a lot
happier with the performance of a table with a couple million rows
than with an array with a couple million entries.

regards, tom lane