Re: Still trouble reindexing - Mailing list pgsql-general

From Tom Lane
Subject Re: Still trouble reindexing
Date
Msg-id 25320.1057129052@sss.pgh.pa.us
Whole thread Raw
In response to Still trouble reindexing  ("Henrik Steffen" <steffen@city-map.de>)
List pgsql-general
"Henrik Steffen" <steffen@city-map.de> writes:
> this night I got the following error message while
> reindexing the same table that hat non-unique values
> the last days:

> DBD::Pg::st execute failed:
> ERROR:  index_formtuple: data takes 536870936 bytes, max is 8191 [for
> statement ``REINDEX TABLE kundenstatistik''])

> Any hint what that could mean?

Ugh :-( ... looks like corrupt data to me, specifically a bad length
word in a variable-length field.  Have you checked your disk hardware
lately?

            regards, tom lane

pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Re: Performance question
Next
From: Tom Lane
Date:
Subject: Re: Performance question