Re: Running out of memory while making a join - Mailing list pgsql-general

From Tom Lane
Subject Re: Running out of memory while making a join
Date
Msg-id 18299.1352904255@sss.pgh.pa.us
Whole thread Raw
In response to Re: Running out of memory while making a join  (Carlos Henrique Reimer <carlos.reimer@opendb.com.br>)
List pgsql-general
Carlos Henrique Reimer <carlos.reimer@opendb.com.br> writes:
> No problem, there is no problem to use "select wm_nfsp.*" but as my concern
> is to prevent this in the future I think I should apply the fix or is there
> a config parameter to abend the backend if it reaches some kind of storage
> limit?

You could start the postmaster under a smaller ulimit setting ...

            regards, tom lane


pgsql-general by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: SSDs - SandForce or not?
Next
From: "Rhys A.D. Stewart"
Date:
Subject: Access disk from plpython