Re: PANIC: unexpected hash relation size - Mailing list pgsql-general
From | Csaba Kalman |
---|---|
Subject | Re: PANIC: unexpected hash relation size |
Date | |
Msg-id | 460E4FCA.4020100@freemail.hu Whole thread Raw |
In response to | Re: PANIC: unexpected hash relation size (Tom Lane <tgl@sss.pgh.pa.us>) |
Responses |
Re: PANIC: unexpected hash relation size
(Tom Lane <tgl@sss.pgh.pa.us>)
|
List | pgsql-general |
Tom Lane writes: > csaba <csaba818@freemail.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
pgsql-general by date: