Re: array column and b-tree index allowing only 8191 bytes

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Celso Pinto <cpinto(at)yimports(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: array column and b-tree index allowing only 8191 bytes
Date: 2008-06-07 16:38:42
Message-ID: 20080607163842.GP16502@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Celso Pinto wrote:

> So my questions are: is this at all possible? If so, is is possible to
> increate that maximum size?

Indexing the arrays themselves is probably pretty useless. Try indexing
the elements, which you can do with the intarray contrib module.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-06-07 17:57:13 Re: accessing table in LIFO order
Previous Message Christophe Simonis 2008-06-07 16:14:20 fitler database list