BUG #1158: tsearch2 trigger crashes machine
От | PostgreSQL Bugs List |
---|---|
Тема | BUG #1158: tsearch2 trigger crashes machine |
Дата | |
Msg-id | 20040530212332.6BF8ECF5033@www.postgresql.com обсуждение исходный текст |
Ответы |
Re: BUG #1158: tsearch2 trigger crashes machine
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1158 Logged by: Werner Bohl Email address: wbohl@deepdata.com PostgreSQL version: 7.4 Operating system: RH Linux 9, kernel 2.4.20-31 Description: tsearch2 trigger crashes machine Details: Using tsearch2's trigger to index a fairly short (varchar(200)) field with names of business crashes Linux. Table used has 39 fields, one of which is the business name. Bulk-inserting thousands of records (>50,000) crashes Linux. Error appeared consistently on 4 import trials, first time @ 130,000 records, second @ 160,000 records, third @ 64,000 records. Table has a pkey and also is indexed 'using gist(FIELD_NAME)' where FIELD_NAME is the tsvector field. Table resides alone in his own db & schema (public). Linux is severly affected and the machine needs a RESET to be able to boot. (shutdown nor init 6 work!!)
В списке pgsql-bugs по дате отправления: