""Steven Mooij"" <[EMAIL PROTECTED]> wrote > > > 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 guess you are Rudolph's friend ;-) Please follow the post "Error when inserting millions of record" in pg-general. Regards, Qingqing ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
