Re: BUG #2168: 45.000.000 records too much?

"Steven Mooij" <steven(at)mooij(dot)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