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-02 16:07:38 |
Message-ID: | f6b7k4$2o3n$2@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.
>
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jason L. Buberel | 2007-07-02 16:21:11 | Re: recovery_target_time ignored or recovery alwaysrecovers to end of WAL |
Previous Message | Gerhard Hintermayer | 2007-07-02 16:05:49 | Re: ERROR: unexpected hash relation size: |