Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eeFI2-00089R-Bn for pgsql-performance@arkaria.postgresql.org; Wed, 24 Jan 2018 07:16:10 +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 1eeFI1-0001RF-Nj for pgsql-performance@arkaria.postgresql.org; Wed, 24 Jan 2018 07:16:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eeFI1-0001R5-GR for pgsql-performance@lists.postgresql.org; Wed, 24 Jan 2018 07:16:09 +0000 Received: from mail-it0-x242.google.com ([2607:f8b0:4001:c0b::242]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1eeFHz-0007cX-57 for pgsql-performance@postgresql.org; Wed, 24 Jan 2018 07:16:09 +0000 Received: by mail-it0-x242.google.com with SMTP id p139so4077106itb.1 for ; Tue, 23 Jan 2018 23:16:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=3zoK+IATA7iPjMygYgmIcK+JeEpxDdfx4ByX81xIo3U=; b=CuAcwrl32p2jyyuYG94zTzlFFSy0rxb6Xi2N3fLbxqfNZKNUbjpL5OXEzA1iksaIED cqwQ0HDZWHSrSFPA0lN2jKYskukpyEcOr8rEgx6j96EsaJY+CdqGREP/+00301cU+Yoy hDKRAknv7HWzFBr8nN44UTT/USg46BtVJmGtWlodgKIqjrRAvCiCO5CZMEam/2yLz4Wx u/pTchr1d/6YGuh3AcY3m7VQhV5unJibZZoZCXqz+QaFq2c90OsyHsNStyL2uvZAGx+m ECIYZKq9cLykah0107GvzTlA3SoZKaiCep75m0l2Ome2d2IRyE0FSo38knm5j617ybVj Hnzg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=3zoK+IATA7iPjMygYgmIcK+JeEpxDdfx4ByX81xIo3U=; b=UzMHz3NmbLDEyVaJKik20rObYBShO07f4mukGQdb0jCwh0680fJou3kGZ72i7/B4jJ uyZg4uz84NPfrp7YwlRQdvN+zpxxDa2Dq2p03Q+3TXS4dLSX1n0ZKHvL172M48svXyXC aCZ3obmPCRPCS2CKiNIeF5VTgMW0rCjkQtxm8fXjB57gAfQJgjF+itBTQfQnBVzH6/1l 5yXNgFA0sS9xsecsiHkhM+N0rD5dFnoUShw6KdF3VQH9nldnq/tQT9LQKJb3bpI9twgt i/J5CGaxB4yjdoqGDxqPVeSKK65iYTLzeEBPPPQSCMYBZb/TuJmEPqkkpVLK+ZDgmnYg xCeQ== X-Gm-Message-State: AKwxytezvOGIYqLwclmoatpBOY4HosRveCPHn4LAYLmTlrVRaEthlBXy 8Rn8GYgRnZabeb1H2juAflyRlNLl X-Google-Smtp-Source: AH8x224AYyrdRE0vXF3unIL0kXf0uYg/UzMDfG9zl3+Gbxxe+fPf3kTbvuOJZKwxo1ad+PTFyRd4XA== X-Received: by 10.36.31.196 with SMTP id d187mr7089287itd.96.1516778164525; Tue, 23 Jan 2018 23:16:04 -0800 (PST) Received: from paquier.xyz (mp76f1fac4.ap.nuro.jp. [118.241.250.196]) by smtp.gmail.com with ESMTPSA id t76sm10719716iof.87.2018.01.23.23.16.01 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Tue, 23 Jan 2018 23:16:03 -0800 (PST) Date: Wed, 24 Jan 2018 16:15:59 +0900 From: Michael Paquier To: pavan95 Cc: pgsql-performance@postgresql.org Subject: Re: need help on memory allocation Message-ID: <20180124071559.GA23081@paquier.xyz> References: <1516773241904-0.post@n3.nabble.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="LyciRD1jyfeSSjG0" Content-Disposition: inline In-Reply-To: <1516773241904-0.post@n3.nabble.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --LyciRD1jyfeSSjG0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Jan 23, 2018 at 10:54:01PM -0700, pavan95 wrote: > If you are finding some sessions then of course your database is > perfectly alright. As sessions won't consume any memory. Those have a cost as well when building transaction snapshots. Too much of them is no good either, let's not forget that. -- Michael --LyciRD1jyfeSSjG0 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlpoMq8ACgkQnvQgOdby QH2VQw/9H1Sbyuy3Ay8dLCixa1dPlVbTxBbVDbYef1V8es/tqOgKbIVIWYOassX5 TonFebpb/NUdfmVOpsH1tZgnpbgl/WJLjTOzflC3dbPAL9zy1CCfMudGh/nsrkB0 CHc5eYosrHsimzbMLoSJnsiMD4kwEy6XW9PYgqvDUN8f2Dc453LqNmC1Q6Ix4EsI RmboonkPz+i9WzZxEflrJu1fjsp9eB73zNkIh0tn9nf9VtCgfI0AYEVW+8LTErTW p128yx/TcrJRHI5FOcgrrLrKxCTUYw+z9tI5rBSysdsOimTjBgFjRKKKc1QVPBuk iM1N7ii91Cns8hm33mbKPEENHkeO/zqo85jFcD7bplAQAeutrnRzMM4p2ZMH99fY otR2NrSDg5be+ppvwle4xQgZfN1lu1/y4WjY3Q/dLiWClYHq4VQCHPrUNoO+spKs bRAk5oJAkn2u6+28k0Rj5C13ktX48f//Wjus1iusd7/bK1JxUUeOHVKe02rfWxwB fPit3FrPNoxoKpIECKFn+GncEqv893Qbm9VHmxgwwykvYUF0aKPtr8OexbTwX0UA sKrxiGc87MO9DTr7F1niQSdwamLKe+vDbBq4vc8grARGPv9wAZHDgr3OQmbIo9U2 1isFWQNoXSI5ArYzCIW09bjc06Qz830ZTPd2IpAtYEwZ/70PwDY= =k6z4 -----END PGP SIGNATURE----- --LyciRD1jyfeSSjG0--