Re: ERROR: unexpected hash relation size:

Martijn van Oosterhout wrote:
> On Mon, Jul 02, 2007 at 11:46:54AM +0200, Gerhard Hintermayer wrote:
>> ... x should be y
>>
>> I do get these messages one 2 of my servers running mostly on identical
>> data. The servers are unix-based and are running 8.1.8 under linux (Gentoo).
>> On one server the message appears only after vacuum-ing, on the other I
>> had some errors after inserting into the table too (about 12 inserts, no
>> more messages except while vacuuming since then)
>
> Has the server crashed recently? Hash indexes are known not to be crash
> safe. Using REINDEX on the index should fix it.
>
> Have a nice day,
No, the server(s) did not crash.
Will do the update Tom Lane sugested ASAP (unfortunately server is
running 7*24 :-( )
Strange, that the error is encountered after more that 2 month running
flawless.

Thanks