Re: [HACKERS] Another nasty cache problem

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