From: | Mike Harding <mvh(at)ix(dot)netcom(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | repeatable crash generating two column index |
Date: | 2002-07-03 17:58:34 |
Message-ID: | 20020703175834.E9AE21310A@netcom1.netcom.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Booth, Robert | 2002-07-03 18:02:00 | Query Analyzing |
Previous Message | eunice palmeira | 2002-07-03 17:56:02 | temporal event |