repeatable crash generating two column index
От | Mike Harding |
---|---|
Тема | repeatable crash generating two column index |
Дата | |
Msg-id | 20020703175834.E9AE21310A@netcom1.netcom.com обсуждение исходный текст |
Ответы |
Re: repeatable crash generating two column index
Re: repeatable crash generating two column index |
Список | pgsql-general |
I'm working the example in "Postgresql Developer's Handbook", page 218. I can create an index on a single column no problem, but when I try to create a index over two columns -> CREATE INDEX idx_id_perftest ON perftest (id, astring); the backend crashes every time. I see the following in the logs... 2002-07-03 08:33:29 DEBUG: server process (pid 53454) was terminated by signal 11 2002-07-03 08:33:29 DEBUG: terminating any other active server processes 2002-07-03 08:33:29 DEBUG: all server processes terminated; reinitializing shared memory and semaphores I can create/drop a single column index after the crash/recovery no problem. I am using FreeBSD 4.6, Postrgresql 7.2.1. I'm not including the code because it's copyright but can forward to a debugger. The code just generates 10 million columns with an ID, and a random number and string... mvh=> select * from perftest limit 10; id | astring | anumber ----+----------+---------- 1 | pIscM5Kh | 35888787 2 | b8FSfFCU | 7206043 3 | 8lkWXbbj | 48537449 4 | DqLhIiZq | 15229027 5 | ic31Ckk9 | 3910172 6 | Gskx5Fqk | 11816527 7 | saifh1ia | 26180953 8 | mlbmdya2 | 5189701 9 | jfOB6cVe | 34855048 10 | cAUg0yIo | 91032333 (10 rows) - Mike H.
В списке pgsql-general по дате отправления: