"Steven Mooij" <steven@mooij.name> 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