ERROR: btree: index item size 2892 exceeds maximum 2713

ERROR: btree: index item size 2892 exceeds maximum 2713

am 13.01.2005 14:46:28 von Ramachandra Putti

Hi all,

Why did I get this error?

Could you please help me?

Regards,
Ramachandra

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Re: ERROR: btree: index item size 2892 exceeds maximum 2713

am 14.01.2005 11:00:19 von Michael Fuhr

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/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings