From: Dmitri Bichko <dbichko@aveopharma.com>
To: Silke Trissl <trissl@informatik.hu-berlin.de>
To: pgsql-sql@postgresql.org
Subject: Re: Indexing an array?
Date: Thu, 8 Sep 2005 12:34:24 -0400
Message-ID: <F18A6F7CF1661F46920F2CF713122FED46CC96@mail.aveo.aveopharma.com> (raw)
Really seems like that array should be a separate table, then Postgres would definitely know how to index it.
Dmitri
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [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?
>
>
> 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ßl
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking 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 computer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dbichko@aveopharma.com, trissl@informatik.hu-berlin.de
Subject: Re: Indexing an array?
In-Reply-To: <F18A6F7CF1661F46920F2CF713122FED46CC96@mail.aveo.aveopharma.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox