Re: index row size exceeds btree maximum, 2713 - Solutions?

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Jaime Casanova <systemguards(at)gmail(dot)com>
Cc: Dan Armbrust <daniel(dot)armbrust(dot)list(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: index row size exceeds btree maximum, 2713 - Solutions?
Date: 2005-07-19 10:42:20
Message-ID: Pine.LNX.4.44.0507191240590.7470-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 18 Jul 2005, Jaime Casanova wrote:

> I don't think you could create indexes on text fields... there are
> other type of indexes for that... tsearch2 for example

You can index text fields, but you can't insert values bigger then
BLOCKSIZE/3 when you have an index on that column.

--
/Dennis Björklund

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-07-19 11:03:35 Re: Old question - failed to find conversion function from
Previous Message Ilja Golshtein 2005-07-19 09:50:06 Old question - failed to find conversion function from "unknown"