Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1een0U-0000Ia-Qy for pgsql-admin@arkaria.postgresql.org; Thu, 25 Jan 2018 19:16:20 +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 1een0U-0002Ev-24 for pgsql-admin@arkaria.postgresql.org; Thu, 25 Jan 2018 19:16:18 +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 1een0S-0002DG-PN for pgsql-admin@lists.postgresql.org; Thu, 25 Jan 2018 19:16:17 +0000 Received: from mail-oln040092002028.outbound.protection.outlook.com ([40.92.2.28] helo=NAM01-SN1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1een0O-0001QD-3T for pgsql-admin@postgresql.org; Thu, 25 Jan 2018 19:16:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=8ji7EFZlpkWjAsPWWEUb7hDw2Qd4nd5kptKCI771fxk=; b=jryIHnj4InexMx7HacP4SkAd5GZ+CeI49nFHA8JSikGYomqGmVDzHDksyKSpGCVmwFfKwet6Zy6XC3g/KW6B764h0xp7CAvDBEt5nCE9SF2bDBwxwH1/7989xKNSRy4yuSbnS4flH3P13niNjU2HN8jGF0n6yxr54CG84hIdhEywccWEXyJEGqIJC8L+h28DlAoMWWbz1An4sEEdQeDe7AHE434Tv1veeFuwxafCGtzzj0mupbQ2l+EatR947UkSEhvyiNITFT0y96vs6cvm0j9MaZEIxNxS17rueRChx7nRGHFUowTj2BJtrTpQmDmNipB6QyWQ/6JtrcxUq4CKRg== Received: from SN1NAM01FT064.eop-nam01.prod.protection.outlook.com (10.152.64.52) by SN1NAM01HT217.eop-nam01.prod.protection.outlook.com (10.152.64.169) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.20.428.12; Thu, 25 Jan 2018 19:16:10 +0000 Received: from CP2P152MB0356.LAMP152.PROD.OUTLOOK.COM (10.152.64.54) by SN1NAM01FT064.mail.protection.outlook.com (10.152.64.230) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.20.444.13 via Frontend Transport; Thu, 25 Jan 2018 19:16:10 +0000 Received: from CP2P152MB0356.LAMP152.PROD.OUTLOOK.COM ([10.171.25.20]) by CP2P152MB0356.LAMP152.PROD.OUTLOOK.COM ([10.171.25.20]) with mapi id 15.20.0428.024; Thu, 25 Jan 2018 19:16:10 +0000 From: Jorge Daniel To: "pgsql-admin@lists.postgresql.org" , "pgsql-admin@postgresql.org" , "dyuryeva@medallia.com" Subject: OOM Killing on Docker while ANALYZE running Thread-Topic: OOM Killing on Docker while ANALYZE running Thread-Index: AQHTlgYM2pwzZwARaU6OiHDnjM+nvw== Date: Thu, 25 Jan 2018 19:16:09 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-incomingtopheadermarker: OriginalChecksum:24CF49C3394DEFAF6C034ACA752DECCDC37E108B3C76C1F17964FC990CB791AF;UpperCasedChecksum:E52DECE6C1A08B451A535667F560CAF2756DAE8BC04CADED459A1CF02C7A9AE5;SizeAsReceived:6973;Count:44 x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [deDZ9W64Tm5R5dp9lABjZxxr2mFZUkYP] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;SN1NAM01HT217;6:pZcQQK5Xq7dNv9PQ6aKP7HZ4fP9GQmFzUzJdf6KqZpBZ5rwNUFo/kIU9SE3c2Bi05x+lJNJBkymSfYfhkBa3SSD6Qb8Zy+sGT6F8psRPCw3LJi0Z5TFfpQrNv2LqRUqkK4Q0Cf4yEIkM4KVMW8f4xk9RjSdXCZdao9Jx8b5ocIv19Zh0fZnjP2rMuzh3VX/oFDJwlOQhp3j83Y3i7lOJhINjM9HuHhtbg2312n0/b+XWjWyjDGgyi2TCLe/0aj3C6Eme+Vj8PSxUb4fGz3yCY4trK8b6RrxVb9vxMQ5X1/cV2Q/h6HehY83JFXs/qFSmgmvB2CneouYEXSaDL81i2IPjxbV1kOP6ZRXypIrlWII=;5:ItB1fZy0cfUWBHuVIvAuPeqi5k9r/szjE35WMq3DWrh/yJ3wrPuFZChfTFr+lNUbDxQNbQ7Tw//JnFi5MNpT8vMTXanOklzEjXn+pEIymGdBiisqsMxVcmLkkNMqa2HS9bN2MuG1KfnCwko6cDO6FXKIAL/LqgaeJlnc65fna+k=;24:jCfgMji3c0kzawz3KbvIV212LGKONtYihOx7e+8hQhmE72oXDzkyvFTjxhbvc5I7Z7bKojONhuXGSy5qeWyTg81csTnrVt41Xy6yXBoaj4Q=;7:Wj6eELUukI5mBJLL+F+SDSk/CbfwBITEZu0PfNDvu1Xuk5DIk2VoDjYkSv2Q9dcWd7SrUJhwMfEzbbUdaTKWZozNAQBX06o80QrWh+QIu9Ir1OL1QFfos2NYAjdYZOl+XWpeC274Hllmp7IXiLJgCZ86oNAWLPEjF/KUYN1A9dbaJpn/Vgdgi2929F9e7NybmMobOsd36JqrUUjQDANh8++i0bRKpaKxy3dDlerg4Gwh9StSSQXNoKzkL9D1Yf10 x-incomingheadercount: 44 x-eopattributedmessage: 0 x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(7020095)(201702061074)(5061506573)(5061507331)(1603103135)(2017031320274)(2017031324274)(2017031323274)(2017031322404)(1601125374)(1603101448)(1701031045);SRVR:SN1NAM01HT217; x-ms-traffictypediagnostic: SN1NAM01HT217: x-ms-office365-filtering-correlation-id: a2f07748-fed8-4f66-8a76-08d56428179c x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(444000031);SRVR:SN1NAM01HT217;BCL:0;PCL:0;RULEID:;SRVR:SN1NAM01HT217; x-forefront-prvs: 0563F2E8B7 x-forefront-antispam-report: SFV:NSPM;SFS:(7070007)(98901004);DIR:OUT;SFP:1901;SCL:1;SRVR:SN1NAM01HT217;H:CP2P152MB0356.LAMP152.PROD.OUTLOOK.COM;FPR:;SPF:None;LANG:; spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_CP2P152MB03563AA07394B591FD640158BCE10CP2P152MB0356LAMP_" MIME-Version: 1.0 X-OriginatorOrg: hotmail.com X-MS-Exchange-CrossTenant-Network-Message-Id: a2f07748-fed8-4f66-8a76-08d56428179c X-MS-Exchange-CrossTenant-originalarrivaltime: 25 Jan 2018 19:16:10.0085 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Internet X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: SN1NAM01HT217 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_CP2P152MB03563AA07394B591FD640158BCE10CP2P152MB0356LAMP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi guys , I'm dealing with OOM killing on Postgresql 9.4.8 running on docke= r , Docker : Docker version 17.05.0, "resources_template =3D Resources(cpu =3D 1,ram =3D 1 * GB, disk =3D 1 * GB= )" Using Ceph volumes as storages ------ Shared Memory Limits -------- max number of segments =3D 4096 max seg size (kbytes) =3D 5079992 max total shared memory (kbytes) =3D 5079992 min seg size (bytes) =3D 1 ------ Semaphore Limits -------- max number of arrays =3D 32000 max semaphores per array =3D 32000 max semaphores system wide =3D 1024000000 max ops per semop call =3D 500 semaphore max value =3D 32767 ------ Messages Limits -------- max queues system wide =3D 32000 max size of message (bytes) =3D 8192 default max size of queue (bytes) =3D 16384 ------ Shared Memory Segments -------- key shmid owner perms bytes nattch status 0x0052e2c1 0 postgres 600 56 5 0x6b8b4567 32769 postgres 600 2028 5 postgres@d90b66757bb1:~$ ipcs -a ------ Shared Memory Segments -------- key shmid owner perms bytes nattch status 0x0052e2c1 0 postgres 600 56 5 0x6b8b4567 32769 postgres 600 2028 5 ------ Semaphore Arrays -------- key semid owner perms nsems 0x0052e2c1 0 postgres 600 17 0x0052e2c2 32769 postgres 600 17 0x0052e2c3 65538 postgres 600 17 0x0052e2c4 98307 postgres 600 17 0x0052e2c5 131076 postgres 600 17 0x0052e2c6 163845 postgres 600 17 0x0052e2c7 196614 postgres 600 17 ------ Message Queues -------- key msqid owner perms used-bytes messages The postgres installation is : PostgreSQL 9.4.8 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2= -19ubuntu1) 4.8.2, 64-bit