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 0AA74D8728 for ; Thu, 8 Sep 2005 13:31:59 -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 45823-02 for ; Thu, 8 Sep 2005 16:31:55 +0000 (GMT) Received: from mail.aveo.aveopharma.com (67.109.105.227.ptr.us.xo.net [67.109.105.227]) by svr1.postgresql.org (Postfix) with SMTP id 75E02D84E7 for ; Thu, 8 Sep 2005 13:31:54 -0300 (ADT) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: Re: Indexing an array? Date: Thu, 8 Sep 2005 12:34:24 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [SQL] Indexing an array? Thread-Index: AcW0kYpWX8A9C1XsQ5OgjX8O3e/6KgAAYgeA From: "Dmitri Bichko" To: "Silke Trissl" , X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.071 required=5 tests=[AWL=0.021, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/85 X-Sequence-Number: 22632 Really seems like that array should be a separate table, then Postgres wo= uld definitely know how to index it. Dmitri > -----Original Message----- > From: pgsql-sql-owner@postgresql.org=20 > [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Silke Trissl > Sent: Thursday, September 08, 2005 12:14 PM > To: pgsql-sql@postgresql.org > Subject: [SQL] Indexing an array? >=20 >=20 > Hi, >=20 > I have a problem with arrays in Postgres. I want to create a=20 > really large array, lets say 3 billion characters long. >=20 > As far I could read from the documentation - this should be=20 > possible. But my question is, is there a kind of index on the array. >=20 > Lets say, I want to get element 2,675,345,328. Does Postgres=20 > have to load the entire array into memory and then run=20 > through the 2.6 billion characters to return the one I want=20 > or does Postgres have an index - as where to find this=20 > element on disk? >=20 > Any advice is welcome and thanks in advance >=20 > Silke Tri=DFl >=20 > =09 >=20 >=20 > ---------------------------(end of=20 > broadcast)--------------------------- > TIP 6: explain analyze is your friend >=20 The information transmitted is intended only for the person or entity to = which it is addressed and may contain confidential and/or privileged mate= rial. Any review, retransmission, dissemination or other use of, or takin= g of any action in reliance upon, this information by persons or entities= other than the intended recipient is prohibited. If you received this in= error, please contact the sender and delete the material from any comput= er