Skip site navigation (1) Skip section navigation (2)

Re: PANIC: unexpected hash relation size

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Csaba Kalman <csaba818(at)freemail(dot)hu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PANIC: unexpected hash relation size
Date: 2007-03-31 17:39:47
Message-ID: 6917.1175362787@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Csaba Kalman <csaba818(at)freemail(dot)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

In response to

pgsql-general by date

Next:From: Joshua D. DrakeDate: 2007-03-31 17:48:03
Subject: Re: Anyone know where I can get an 8.2.3 binary for ubuntu?
Previous:From: Ron JohnsonDate: 2007-03-31 17:28:18
Subject: Re: Anyone know where I can get an 8.2.3 binary for ubuntu?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group