X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 67BF4D89CF
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  8 Sep 2005 13:13:57 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 37768-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  8 Sep 2005 16:13:51 +0000 (GMT)
Received: from mail.informatik.hu-berlin.de (mail.informatik.hu-berlin.de
	[141.20.20.50])
	by svr1.postgresql.org (Postfix) with ESMTP id 3DCC8D89E0
	for <pgsql-sql@postgresql.org>; Thu,  8 Sep 2005 13:13:49 -0300 (ADT)
Received: from [141.20.27.143] (karotte.informatik.hu-berlin.de
	[141.20.27.143]) (authenticated bits=0)
	by mail.informatik.hu-berlin.de
	(8.13.4+Sun/8.13.4/INF-2.0-MA-SOLARIS-2.10) with ESMTP id
	j88GDjH5012012
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO)
	for <pgsql-sql@postgresql.org>; Thu, 8 Sep 2005 18:13:45 +0200 (CEST)
Message-ID: <43206338.9020502@informatik.hu-berlin.de>
Date: Thu, 08 Sep 2005 18:13:44 +0200
From: Silke Trissl <trissl@informatik.hu-berlin.de>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.10) Gecko/20050727
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Indexing an array?
X-Enigmail-Version: 0.90.1.0
X-Enigmail-Supports: pgp-inline, pgp-mime
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Status: No (mail)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0 required=5 tests=[none]
X-Spam-Level: 
X-Archive-Number: 200509/83
X-Sequence-Number: 22630

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 2,675,345,328. Does Postgres have to
load the entire array into memory and then run through the 2.6 billion
characters to return the one I want or does Postgres have an index - as
where to find this element on disk?

Any advice is welcome and thanks in advance

	Silke Tri=DFl

=09