Re: [GENERAL] Error when inserting millions of records

2006-01-19 Thread Rudolph 
Steven also submitted this subject in the bugs list: BUG #2168:
45.000.000 records too much?. He also posted more details and how to
reproduce the bug.

Andrew, no special constraints or triggers were used.

Thanks, Rudolph


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

Re: [GENERAL] Error when inserting millions of records

2006-01-14 Thread Andrew - Supernews 
On 2006-01-13, Rudolph [EMAIL PROTECTED] wrote:
 Me and a friend are testing some operations for a search application in
 PostgreSQL. In version 8.1 my friend tried to copy the result of a join
 into another table, about 45.000.000 (small) records. This is the
 result:

Do you have any constraints, especially deferred constraints, or triggers
on the table? Are there any functional indexes?

-- 
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

[GENERAL] Error when inserting millions of records

2006-01-14 Thread Rudolph 
Me and a friend are testing some operations for a search application in
PostgreSQL. In version 8.1 my friend 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.

He got the same result in version 7.5.15.

Anyone any ideas what this could be?


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

Re: [GENERAL] Error when inserting millions of records

2006-01-13 Thread Qingqing Zhou 

Rudolph [EMAIL PROTECTED] wrote
 Me and a friend are testing some operations for a search application in
 PostgreSQL. In version 8.1 my friend 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.

 He got the same result in version 7.5.15.


Do we have a 7.5.15 version? You can get the right version using SELECT 
version();.

What's the structure of t_documentword2 and t_documentword? If you got core 
dumps, it will be useful to print the backtrace.

Regards,
Qingqing 



---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq