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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Bert <biertie(at)gmail(dot)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