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 <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 (view raw or flat)
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

pgsql-general by date

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

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