Re: Indexing an array?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Silke Trissl <trissl(at)informatik(dot)hu-berlin(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Indexing an array?
Date: 2005-09-08 16:33:45
Message-ID: 8423.1126197225@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Silke Trissl <trissl(at)informatik(dot)hu-berlin(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Dmitri Bichko 2005-09-08 16:34:24 Re: Indexing an array?
Previous Message mark 2005-09-08 16:28:45 Re: uuid type for postgres