Indexing an array?

Поиск
Список
Период
Сортировка
От Silke Trissl
Тема Indexing an array?
Дата
Msg-id 43206338.9020502@informatik.hu-berlin.de
обсуждение исходный текст
Ответы Re: Indexing an array?
Re: Indexing an array?
Re: Indexing an array?
Список pgsql-sql
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




В списке pgsql-sql по дате отправления: