| From: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: OOM Killing on Docker while ANALYZE running |
| Date: | 2018-01-26 04:15:39 |
| Message-ID: | 41aac336-d5ed-9cf2-15d8-cf3783b7fea5@catalyst.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 26/01/18 15:51, Ray Stell wrote:
> On 1/25/18 3:48 PM, Tom Lane wrote:
>
>> Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
>>> Jorge Daniel wrote:
>>>> Hi guys , I'm dealing with OOM killing on Postgresql 9.4.8 running
>>>> on docker
>
> Mike Coleman's talk at DockerCon17 is here:
> http://training.play-with-docker.com/ops-stage1/
> At about the 38 minute mark, on the topic of transitioning enterprise
> apps to docker:
> "define your guardrails, leave the db out in the VM." Mike is a
> docker evangelist.
>
>
Hmm - I don't think docker per se is the problem here - that
default_statistics_target of 10000 is the more likely culprit. A minimal
allowance of resources (e.g memory in this case) combined with hugely
over spec'ed memory use (the default_statistics_target setting) is gonna
trigger OOM for any environment.
regards
Mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2018-01-26 14:32:36 | permission denied (even when run as postgres) for views after making their owner nosuperuser |
| Previous Message | Ray Stell | 2018-01-26 02:51:36 | Re: OOM Killing on Docker while ANALYZE running |