"Steven Mooij" <[EMAIL PROTECTED]> writes: > 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
There's not enough information here to guess what the problem is. (But it's not table size; people routinely manipulate tables much bigger than that in Postgres.) A stack trace from the core dump would be really helpful, or even better a self-contained test case that other people could replicate the failure with. See the bug reporting guidelines at http://www.postgresql.org/docs/8.1/static/bug-reporting.html > I got the same result in version 7.5.15. There is no version of Postgres named 7.5.anything. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster