Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wxye9-0007MQ-Tw for pgsql-general@arkaria.postgresql.org; Fri, 20 Jun 2014 13:14:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Wxye8-0008DK-SS for pgsql-general@arkaria.postgresql.org; Fri, 20 Jun 2014 13:14:24 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Wxydz-0007zH-9I for pgsql-general@postgresql.org; Fri, 20 Jun 2014 13:14:15 +0000 Received: from nm12.bullet.mail.ne1.yahoo.com ([98.138.90.75]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1Wxydv-0006eZ-UZ for pgsql-general@postgresql.org; Fri, 20 Jun 2014 13:14:13 +0000 Received: from [98.138.100.111] by nm12.bullet.mail.ne1.yahoo.com with NNFMP; 20 Jun 2014 13:14:10 -0000 Received: from [98.138.89.165] by tm100.bullet.mail.ne1.yahoo.com with NNFMP; 20 Jun 2014 13:14:10 -0000 Received: from [127.0.0.1] by omp1021.mail.ne1.yahoo.com with NNFMP; 20 Jun 2014 13:14:10 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 170707.87215.bm@omp1021.mail.ne1.yahoo.com Received: (qmail 21401 invoked by uid 60001); 20 Jun 2014 13:14:10 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1403270050; bh=MXG7F1KEra/rePN/cQTIfDGtIfKIUzD9w3wCXrpUQqE=; h=References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=j0lRHM0ESoA7WIiiTDsUN1mKjhp3a7rrD5h1Oh2u+8WZ9sDy3nc/si0wEMcHunI76B5ogcCblUyqARE+pAqIiwP3hj5Gw28iJZu3PF1slXNKoau+mvfttLUBdO9/WlaB5qry1nClylg46yT/L8mWG4IQ+xyeveISMhMw+kO37nU= X-YMail-OSG: zBfWnREVM1kOHSjcBpmdvmRJP2_qSXqx6v1RGLf4NGfHrLs fY7ABgqCX9vk0JT4zErh9Q5ewt5wYMM7Ch9YhGMvGhecAIxVz3IpcnsXNuhJ Wp_i10IluVt6bkzZc1237L53FFWCwHoi0N8Dbx_ARhho3B5rxaN3Y1Qndknh Z7j1mKJlrMh4Vb1y3JDZ7btLtCGL.wU2dlCJkPKdr8gM5clEV6mVbSBAwmuy ajy4.AYYmOAFwh1TwsviCSK8aEatBWNQ0IBvUFzExkMXijmWdrXwfxWC1L5m 8VNVWXXhwkfB_KPRPfpjtDR73mWrzLScT.8NxgobWjncNzz134a0h.SmX72A 7DiivbaYp_AlwZS.k5Kedv8sYoX52.NPQzn7OYDtADhGNwnWdMaego_21Rxy qYqS2y4t2iSghitPqlASM2pNg_FCE_ZFi1rZ8QjDcPvMmJCIIcdGn5._9kxY Us.g3fLLLXQNEB1HG2KBeXHkuKlwI_47M2fIjRvWE73DDyD.umIqboEi5npB 9I.FGAXziIfg2ufL8E49ZVAXVfbUl7ZkOBzBdc3S2ZNcbpH7sNJyWjxaaeWI PMYTyeZdXFTp.XP0bNw-- Received: from [24.178.25.147] by web122303.mail.ne1.yahoo.com via HTTP; Fri, 20 Jun 2014 06:14:10 PDT X-Rocket-MIMEInfo: 002.001, T2xpdmVyIDxvZmFiZWxvQGdtYWlsLmNvbT4gd3JvdGU6Cgo.IERCIGhhc24ndCBhY3Rpdml0eSBub3cgYmVjYXVzZSBpdCBpcyBhIG5ldyBpbnN0YW5jZSwgdG9wIGNvbW1hbmQKPiBpbmRpY2F0ZXMgb25seSAzNTBNQiBvZiB1c2VkIG1lbW9yeSAuLiBJIHVuZGVyc3RhbmQgdGhhdAo.IHBvc3RncmVzcWwgY291bGQgcmVhY2ggdW50aWwgMkdCIG9mIHNlcnZlciBtZW1vcnkgYXMgdG90YWwsCj4gY29ycmVjdD8KCkl0J3MgdXN1YWxseSBtdWNoIGJldHRlciB0byBjb3B5L3Bhc3RlIHdoYXQgeW91J3JlIHRhbGsBMAEBAQE- X-Mailer: YahooMailWebService/0.8.191.1 References: Message-ID: <1403270050.71164.YahooMailNeo@web122303.mail.ne1.yahoo.com> Date: Fri, 20 Jun 2014 06:14:10 -0700 From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: Postgresql not getting assigned memory To: Oliver , Abdul Sayeed Cc: "pgsql-admin@postgresql.org" , Forums postgresql In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org Oliver wrote: > DB hasn't activity now because it is a new instance, top command > indicates only 350MB of used memory .. I understand that > postgresql could reach until 2GB of server memory as total, > correct? It's usually much better to copy/paste what you're talking about than to just refer to it.=A0 On the varieties of Linux I use, if you're talking about the virtual memory, the full size should be included there for every postgres backend process which has connected to it, while only the portion which has been accessed by each backend will be included in its shared or resident memory. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --=20 Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general