Search Postgresql Archives

UPDATE failed with 'ERROR: index row requires 8968 bytes, maximum size is 8191'

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Greetings,
I've got a postgresql-8.4.7 instance running on 64bit Linux that
recently failed a SQL UPDATE with the error:
ERROR:  index row requires 8968 bytes, maximum size is 8191

The index in question that failed is defined as:
"results_failinfo_index" btree (failinfo)

Its extermely rare, but not impossible that this will happen again
(most of the updates to this table column are significantly smaller in
size).  Therefore, I'd rather not redesign the table schema if I can
come up with some safety net work around.

It looks like this describes my situation perfectly (
http://tiki.org/TikiPostgres#Saving_large_amounts_of_text. ).  If I'm
understanding this correctly, it sounds like I could attempt this
workaround, and I need to add a where clause to the index to limit the
length of the data that gets indexed?  If so, what would I specify for
the upper limit on the length of the data?

thanks!

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux