Re: PANIC: unexpected hash relation size

Tom Lane writes:
> 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.
>

A row in table Munkalap represents a job, an employee has to do.

teljesites_datum
About 2-300 rows have the same date.

statusz_pk
It's a reference to another table which describes the different states a job
can be in. There are 10 of them. Contains only numeric values. When a row is
inserted it's value is always '000000100000'. Possible values are 0 through
9 at the last digit. On a long term most rows will have '000000100004' in
this column (that is the final state.)

napi_munka_pk
Reference to a table which contains data about grouping the jobs. Contains
only numeric values. When inserting a row it is always null. Groups are
created at a later stage, then the Munkalap table is updated. About 20-30
rows have the same value if it is not null and there's always a few hundred
rows with null.

A few sample rows:

INSERT INTO munkalap VALUES ('100000003176', '000000100000', '100000003170',
NULL, '100000003171', '900000016024', NULL, 'M07I000005', '2007-03-29',
NULL, NULL, B'0', 'igen', '100000003122', 'Nagy Pistike', '723-5467', 'a',
'', '0', '2007-03-28 18:19:31.828', 4, '', NULL, NULL, NULL);

INSERT INTO munkalap VALUES ('100000003646', '000000100000', '100000003640',
NULL, '100000003641', '900000027306', NULL, 'M07I000052', '2007-04-04',
NULL, NULL, B'0', 'igen', '100000003123', 'Kis Moricka', '946-4861', 'a',
'', '0', '2007-03-28 19:07:25.546', 2, '', NULL, NULL, NULL);

INSERT INTO munkalap VALUES ('100000003761', '000000100001', '100000002783',
'100000005939', '100000003756', '900000161044', '100000007745',
'M07I000064', '2007-03-30', NULL, NULL, B'0', 'nem', '100000003122', 'Toth
Geza', '864-1135', 'a', '', '1', '2007-03-28 19:16:04.187', 2, '', NULL,
NULL, NULL);

INSERT INTO munkalap VALUES ('100000004314', '000000100001', '100000002637',
'100000005914', '100000004309', '900000097696', '100000007740',
'M07I000127', '2007-03-30', NULL, NULL, B'0', 'nem', '100000003122', 'Rizi
Rozi', '955-1919', 'a', '', '1', '2007-03-28 19:56:01', 1, '13', NULL, NULL,
NULL);

Thank you,
Csaba