It seems that I am still tracking problems, but each time they turn out to
have a different cause: A slight variant on the select that caused memory
to run out gives
newnham=# select crsids.surname, "tblPerson"."Surname" from crsids,"tblPerson" where
crsids.usn="tblPerson"."USN"::int4;
pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
Nested Loop (cost=66496.62 rows=34359 width=40) -> Seq Scan on tblPerson (cost=157.62 rows=2625 width=24) -> Seq
Scanon crsids (cost=25.27 rows=584 width=16)
this is the table I based the memory hog on (2600*600). The backend closes
instantly ie., no memory usage! And, as before, it is hard to find a test case
that will do the same as repeatably (ie., test case never crashes, the
above case crashes every single time). "tblPerson", as its strange
capitalisation suggests, was imported from M$ access via ODBC.
select test.txt,test2.var from test,test2 where test2.i=test.var::int4;
Nested Loop (cost=63504.80 rows=2600 width=40) -> Seq Scan on test2 (cost=24.80 rows=600 width=16) -> Seq Scan on
test (cost=105.80 rows=2600 width=24)
works fine.
Any thoughts on where to look?
Cheers,
Patrick