Re: slave restarts with kill -9 coming from somewhere, or nowhere

[Bert <biertie@xxxxxxxxx>]

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@xxxxxxxxxxxxx> wrote:

Bert <biertie@xxxxxxxxx> 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