From: | "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1158: tsearch2 trigger crashes machine |
Date: | 2004-05-30 21:23:32 |
Message-ID: | 20040530212332.6BF8ECF5033@www.postgresql.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1158
Logged by: Werner Bohl
Email address: wbohl(at)deepdata(dot)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!!)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-05-31 04:45:12 | Re: BUG #1158: tsearch2 trigger crashes machine |
Previous Message | Mr sangameswar m | 2004-05-27 13:56:09 | Re: BUG #1156: Database is not initializing |