aha, ok. This was a setting pg_tune sugested. But I can understand how that is a bad idea.
wkr, Bert On Thu, Apr 4, 2013 at 8:17 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Bert <bier...@gmail.com> writes: > > These are my memory settings: > > work_mem = 4GB > > > How is it possible that one connection (query) uses all the ram? And how > > can I avoid it? > > Uh ... don't do the above. work_mem is the allowed memory consumption > per query step, ie per hash or sort operation. A complex query can > easily use multiples of work_mem. > > regards, tom lane > -- Bert Desmet 0477/305361
