On Thu, Feb 03, 2000 at 12:00:21PM -0500, Tom Lane wrote:
>
> The majority of Unix systems have a process size limit kernel parameter,
> which is normally set to less than the amount of available swap space
> (you don't want a single process running wild to chew up all your swap
> and make other stuff start failing for lack of swap...) Check your
> kernel parameters.
Probably to do with the shell limit:
memoryuse 125460 kbytes
> There's a separate question about *why* such a simple query is chewing
> up so much memory. What query plan does EXPLAIN show for your test
> query?
test=# explain select * from test,test2 where test.i!=test2.i;
NOTICE: QUERY PLAN:
Nested Loop (cost=64104.80 rows=1559400 width=56) -> Seq Scan on test2 (cost=24.80 rows=600 width=28) -> Seq Scan
ontest (cost=106.80 rows=2600 width=28)
EXPLAIN
> You said this was with current sources, right?
They're about 2 days old now. (Well, after your SI buffer overrun fixes)
Cheers,
Patrick