"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
