Silke Trissl wrote:
As far I could read from the documentation - this should be possible.
But my question is, is there a kind of index on the array.
If your needs are a bit more modest (say, a few thousands instead of
billions) the stuff in contrib/intarray works well; and if you
needed
Hi,
I have a problem with arrays in Postgres. I want to create a really
large array, lets say 3 billion characters long.
As far I could read from the documentation - this should be possible.
But my question is, is there a kind of index on the array.
Lets say, I want to get element
Silke,
I have a problem with arrays in Postgres. I want to create a really
large array, lets say 3 billion characters long.
Change your application design.
--
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 2:
@postgresql.org
Subject: [SQL] Indexing an array?
Hi,
I have a problem with arrays in Postgres. I want to create a
really large array, lets say 3 billion characters long.
As far I could read from the documentation - this should be
possible. But my question is, is there a kind of index
Silke Trissl [EMAIL PROTECTED] writes:
I have a problem with arrays in Postgres. I want to create a really
large array, lets say 3 billion characters long.
Forget it --- quite aside from indexing inefficiencies, the max size of
an array (or any other single field) is just 1Gb. Don't try to use