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