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 on test (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