Re: Indexing an array? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Indexing an array?
Date
Msg-id 8423.1126197225@sss.pgh.pa.us
Whole thread Raw
In response to Indexing an array?  (Silke Trissl <trissl@informatik.hu-berlin.de>)
List pgsql-sql
Silke Trissl <trissl@informatik.hu-berlin.de> 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
arrays to replace tables.
        regards, tom lane


pgsql-sql by date:

Previous
From: "Dmitri Bichko"
Date:
Subject: Re: Indexing an array?
Next
From: Michael Fuhr
Date:
Subject: Re: Statistics from Sequences