Re: ERROR: unexpected hash relation size: - Mailing list pgsql-general

From Gerhard Hintermayer
Subject Re: ERROR: unexpected hash relation size:
Date
Msg-id f6b7k4$2o3n$2@news.hub.org
Whole thread Raw
In response to Re: ERROR: unexpected hash relation size:  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Gerhard Hintermayer <g.hintermayer@inode.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.
>
> http://developer.postgresql.org/pgdocs/postgres/release-8-1-9.html
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>
Thanks, will do that ASAP.
But strange, that this problem is encoutered after 2 month running 8.1.8
flawless (without any changes to indices and database scheme)

Regards
Gerhard

pgsql-general by date:

Previous
From: Gerhard Hintermayer
Date:
Subject: Re: ERROR: unexpected hash relation size:
Next
From: "Jason L. Buberel"
Date:
Subject: Re: recovery_target_time ignored or recovery alwaysrecovers to end of WAL