Re: ERROR: btree: index item size 3048 exceeds maximum 2717 - Mailing list pgsql-bugs

From Dirk Lutzebaeck
Subject Re: ERROR: btree: index item size 3048 exceeds maximum 2717
Date
Msg-id 14847.60138.357027.208494@ampato.core.aeccom.com
Whole thread Raw
In response to ERROR: btree: index item size 3048 exceeds maximum 2717  (Dirk Lutzebaeck <lutzeb@aeccom.com>)
List pgsql-bugs
Dirk Lutzebaeck writes:

 > ERROR:  btree: index item size 3048 exceeds maximum 2717
 >
 > This is on 7.0.2 while doing an INSERT. The INSERT aborts and returns
 > this error. It just occurred now for the first time and now everytime.
 > There are several indexes defined on this table. Should I rebuild
 > them all?
 >
 > What is this?

Ok, this looks like an index on a TEXT column can't cope with more
than 2717 octets. I would expect the 8k limit here but it seems
less. I understand that indexing on such long fields may not be
meaningful. But in my application 90% of the text data is very small
but some entries are quite large.

Dirk

pgsql-bugs by date:

Previous
From: Dirk Lutzebaeck
Date:
Subject: ERROR: btree: index item size 3048 exceeds maximum 2717
Next
From: "Vasileiadis Spyros"
Date:
Subject: