Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eeu7L-000146-1g for pgsql-admin@arkaria.postgresql.org; Fri, 26 Jan 2018 02:51:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eeu7K-0004do-I3 for pgsql-admin@arkaria.postgresql.org; Fri, 26 Jan 2018 02:51:50 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eeu7K-0004df-7k for pgsql-admin@lists.postgresql.org; Fri, 26 Jan 2018 02:51:50 +0000 Received: from omr1.cc.ipv6.vt.edu ([2607:b400:92:8300:0:c6:2117:b0e] helo=omr1.cc.vt.edu) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eeu7G-0003Rq-Oh for pgsql-admin@lists.postgresql.org; Fri, 26 Jan 2018 02:51:48 +0000 Received: from mr3.cc.vt.edu (mr3.cc.vt.edu [IPv6:2607:b400:92:8500:0:7f:b804:6b0a]) by omr1.cc.vt.edu (8.14.4/8.14.4) with ESMTP id w0Q2piZs024854 for ; Thu, 25 Jan 2018 21:51:44 -0500 Received: from mail-qt0-f198.google.com (mail-qt0-f198.google.com [209.85.216.198]) by mr3.cc.vt.edu (8.14.7/8.14.7) with ESMTP id w0Q2pdY2021122 for ; Thu, 25 Jan 2018 21:51:44 -0500 Received: by mail-qt0-f198.google.com with SMTP id d15so14082641qtg.2 for ; Thu, 25 Jan 2018 18:51:44 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=dL28qq/4WwmctY06eQ0lhyNWHI2BDTDIkRHDdoDJ3q0=; b=h0VEEP6mXv5ZTT7r7ZJn631h3oWNrlkDzNrPqdMdIQ8pjw4IYDbwXjKUgcW7fQ/y84 NeVDfpiDvH4pOZbjRwR8jMYUAayp+XFQamxKsp9Bqd2t0YwrjQxU1VmqKRMYrt1gqdmh 8Rb7s8KgW07xCx/C3n6OffrmGsj/J2GaPKvJLkeJwYIvrstt/BAo3VX1BQmf29t2GviE mdn1FMQ0ObHdXQ+9l8+lvfVPrP14cKKtlieI+TyiG9GAfLsTMnCYFO8UHW5nuFJ6vWzI lSvrurc6gICE8+EE/1RGNDts2fQV/dtL/BYRxWxHFxxmIgYwfvMY2DRFGAjOq2o/Y3JF fVkw== X-Gm-Message-State: AKwxytdg7tr78bGGghS5j8uDP43zim7PyKjuCBEuu5hDKxGSa1Q0lqVl B5+yoPB6om0pCg3LS3iCKolJmCYbgn5Wb9F6N6u7iLmp0miDB8R/yBpbH2vmN4BIbBRTXyI1Pm2 zUvE5sDdHhxn4hdQ5SWwHrsqefJKcCvuK04wnt0z4WdeVK2eAm0E0jTeFPBd9/bhyAb2PEm5QVV cjbGFv96/U X-Received: by 10.200.51.103 with SMTP id u36mr2001093qta.127.1516935099161; Thu, 25 Jan 2018 18:51:39 -0800 (PST) X-Google-Smtp-Source: AH8x226/KjWcqjnzuYqAzIIIH6qj/kPzQTYzUwxLX8HdJLl+ySBrPpj8muPxl31WopN+kQlCN3P32g== X-Received: by 10.200.51.103 with SMTP id u36mr2001085qta.127.1516935098953; Thu, 25 Jan 2018 18:51:38 -0800 (PST) Received: from stell-home.local (pool-108-4-191-16.ronkva.east.verizon.net. [108.4.191.16]) by smtp.gmail.com with ESMTPSA id m31sm4528254qtd.23.2018.01.25.18.51.37 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 25 Jan 2018 18:51:38 -0800 (PST) Subject: Re: OOM Killing on Docker while ANALYZE running To: pgsql-admin@lists.postgresql.org References: <20180125194720.ammwkya3dvj23rjc@alvherre.pgsql> <29102.1516913306@sss.pgh.pa.us> From: Ray Stell Message-ID: <4e519ceb-d4ff-1cbf-1536-a96a79426ea2@vt.edu> Date: Thu, 25 Jan 2018 21:51:36 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:52.0) Gecko/20100101 Thunderbird/52.5.2 MIME-Version: 1.0 In-Reply-To: <29102.1516913306@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 1/25/18 3:48 PM, Tom Lane wrote: > Alvaro Herrera 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.