Re: PANIC: unexpected hash relation size

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: csaba <csaba818(at)freemail(dot)hu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PANIC: unexpected hash relation size
Date: 2007-03-30 21:28:50
Message-ID: 23732.1175290130@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

csaba <csaba818(at)freemail(dot)hu> writes:
> Here is the CREATE script of the table which is most likely to be one
> source of the error. The last error happened after an insert into this
> table.

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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Harris 2007-03-30 22:16:00 Re: Slow sequential scans on one DB but not another; fragmentation?
Previous Message csaba 2007-03-30 21:21:53 Re: PANIC: unexpected hash relation size