Postgres Pro
Downloads
Home   >   mailing lists

Re: slave restarts with kill -9 coming from somewhere, or nowhere - Mailing list pgsql-admin

From Tom Lane
Subject Re: slave restarts with kill -9 coming from somewhere, or nowhere
Date
Msg-id 6146.1365056278@sss.pgh.pa.us
Whole thread Raw
In response to Re: slave restarts with kill -9 coming from somewhere, or nowhere  (Bert <biertie@gmail.com>)
Responses Re: slave restarts with kill -9 coming from somewhere, or nowhere  (Bert <biertie@gmail.com>)
List pgsql-admin
Tree view 
Bert <biertie@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

pgsql-admin by date:

Previous
From: Bert
Date:
Subject: Re: slave restarts with kill -9 coming from somewhere, or nowhere
Next
From: Bert
Date:
Subject: Re: slave restarts with kill -9 coming from somewhere, or nowhere