Re: ERROR: unexpected hash relation size:

From: Gerhard Hintermayer <g(dot)hintermayer(at)inode(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: unexpected hash relation size:
Date: 2007-07-09 08:20:55
Message-ID: f6sqsp$1md2$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> Gerhard Hintermayer <g(dot)hintermayer(at)inode(dot)at> writes:
>> ... 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).
>
> Update.
>
I thought the fixed error was related to running VACUUM FULL, so I
disabled running it once a week to prevent currupting my indices. (btw I
do not use autovacuum)
But I still get occasional error log entries of this kind (one attempt
to insert), is the fixed error in 8.1.9 also related to growing index
size or is there any other bug burried somewhere. I'm planning to
upgrade the upcoming weekend, so I could investigate some more.

regards
Gerhard

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ragnar 2007-07-09 08:51:36 Re: Database Insertion commitment
Previous Message Wouter Gazendam 2007-07-09 07:43:00 How to obtain a sequence's increment value from the system catalog