| From: | "Steven Mooij" <steven(at)mooij(dot)name> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #2168: 45.000.000 records too much? |
| Date: | 2006-01-13 13:51:16 |
| Message-ID: | 20060113135116.64365F0B01@svr2.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2168
Logged by: Steven Mooij
Email address: steven(at)mooij(dot)name
PostgreSQL version: 8.1
Operating system: Linux
Description: 45.000.000 records too much?
Details:
Tried to copy the result of a join into another table, about 45.000.000
(small) records. This is the result:
testsearch=> insert into t_documentword2 (SELECT document_id, t_word2.id,
frequency from t_documentword, t_word2 where t_documentword.word =
t_word2.word);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
I got the same result in version 7.5.15.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Qingqing Zhou | 2006-01-13 18:44:37 | Re: BUG #2167: Performance degradation |
| Previous Message | Sunil Basu | 2006-01-13 04:39:34 | BUG #2167: Performance degradation |