> 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
No comments:
Post a Comment