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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bert <biertie(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: slave restarts with kill -9 coming from somewhere, or nowhere
Date: 2013-04-04 06:17:58
Message-ID: 6146.1365056278@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bert 2013-04-04 06:39:10 Re: slave restarts with kill -9 coming from somewhere, or nowhere
Previous Message Bert 2013-04-04 06:02:04 Re: slave restarts with kill -9 coming from somewhere, or nowhere