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

From Tom Lane
Subject Re: PANIC: unexpected hash relation size
Date
Msg-id 6917.1175362787@sss.pgh.pa.us
Whole thread Raw
In response to Re: PANIC: unexpected hash relation size  (Csaba Kalman <csaba818@freemail.hu>)
List pgsql-general
Csaba Kalman <csaba818@freemail.hu> writes:
> Tom Lane writes:
>> Hm, what can you say about the data that goes into the three columns
>> that have hash indexes?  I'm going to try testing this with random data,
>> but it'd likely be more useful if I could reproduce your data
>> distribution.

> [ some info ]

Thanks, but I've been unable to reproduce the problem with either random
data or data tailored to match yours.  I'm a bit worried that the issue
may only appear on Windows --- hash indexes currently assume that the
filesystem will react in a particular way to a write that's well beyond
the current EOF, and I wouldn't put it past Microsoft to get that wrong.

Can you put together a self-contained script that causes the error for
you?  It's okay if it only fails once every ten or even 100 tries.
What we need is something that other people can run and say fairly
definitively "it happens here" or "it doesn't".

            regards, tom lane

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Anyone know where I can get an 8.2.3 binary for ubuntu?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Anyone know where I can get an 8.2.3 binary for ubuntu?