"Rudolph" <rudolph.froger@xxxxxxxxx> 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
