Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: btree: index item size 2892 exceeds maximum 2713 - Mailing list pgsql-admin

From Michael Fuhr
Subject Re: ERROR: btree: index item size 2892 exceeds maximum 2713
Date
Msg-id 20050114100019.GA98043@winnie.fuhr.org
Whole thread Raw
In response to ERROR: btree: index item size 2892 exceeds maximum 2713  (Ramachandra Putti <ramachandrap@dpsl.net>)
List pgsql-admin
Tree view 
On Thu, Jan 13, 2005 at 07:16:28PM +0530, Ramachandra Putti wrote:

> Why did I get this error?

You're trying to index a value that's larger than 1/3 of your page
size.  What is the column used for?  Do you really need to index
such a large value?  There might be other ways to index the column,
such as using contrib/tsearch2 if you need full text searches.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-admin by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Pg8 for Windows
Next
From: Bradley Kieser
Date:
Subject: Script terminates even though ON_ERROR_STOP not set