Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lSZZZ-0005DA-21 for pgsql-admin@arkaria.postgresql.org; Sat, 03 Apr 2021 06:15:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lSZZW-00015K-BD for pgsql-admin@arkaria.postgresql.org; Sat, 03 Apr 2021 06:15:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lSZZV-00015C-7d for pgsql-admin@lists.postgresql.org; Sat, 03 Apr 2021 06:15:49 +0000 Received: from sonic308-21.consmr.mail.sg3.yahoo.com ([106.10.241.211]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lSZZO-0004LG-ET for pgsql-admin@lists.postgresql.org; Sat, 03 Apr 2021 06:15:47 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1617430538; bh=L/Z6uVugGwnKlyXTPuPaGK4Na6woSIk2w9FFgU5DMnQ=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=IGXpCjtvT80d88O1bzwNvk4gPHuE3J7/iq/uH0Pf9wFJ4C8MIjHmUUx9YADfb5KAmoN8EiRlUo9KgZXLcVsPgaOUry75ZYHAA6U/QqaTVduSNOLky/LF6tfZbxJavsYOGZjD+A1jvY+kFF7SmZFrwluJryv8YC6aPWtyCoTKjK5XdObPzfEm8uvScfuu0ERaZowQ3x/GZDYTU0xKA37LtsxYad/3Wu35I3/JpaKwScsyWzEuJYn+1TNDNt6t8ZeCuI75W+qW4quJp4WAbUwgYPiHx9//6To7icq2fX3uNxil7brrmJWzz+MiQlYeOvDVuvpHF2DM8Hea/iBjqb/keg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1617430538; bh=ugMNC90eXgtBCQ86ZIXJCuHimjq18SENMKlAd6mAOF3=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=iRt40DHCO+QBl6j6hD5KGWO1WjHygiJMCbLJO6jXZ0HzMmAK9vvWuW9pfqQfJhsyyuDPjDT1BmySGq1JazfueRzcV+9PwEnIp8iU85fgN3VKtsl8Ww5NcBPMp92mWS3f1D0T7oBtJbW832huC4+Nmm/U/beNILenUA5VAowEKWRGKw2VDGEjYlFPxRXIPuhbPQLrW9Q8q1QeSmt/p5LmmS8RM0i8f4bYAoP5NgmTV1A5UORHKIV0XwRcVcfYANRLtL2hj51u08bzqprsOo4LsWe+BvlW+dwBoCIx8tGga/4IxxBqAAGuU6Dlqw1zPnF6cL8wdMteQNqFC3jXgV3PVQ== X-YMail-OSG: 6R0fZs0VM1lVBD.Sa2x5BNAQbQU3xzX5MzLPCdkvwaxHceBeOEKazIW9q_zN778 DT4y64HRFxJQcxZ2eBs1xASTYzep4oSHbRivlUm1J8CkywPl306Br1x91AY6RS5C0CUgV2.dyaDO n30HD84CdlR7VvsLlV2Wo0SzJ4gW5bB578DU6N36wYFe2I_YJevY9fpWuV4JvNNohrAGFf6PPWwi xHdc_3w.flmTwGPXDjXkc_J.dXG9hSQW7hE6Yybr8UZlJq1_QG3HVhdWGANecAmRKFMZio0rZNrD T.wycH5Sa5_GX6vKdKnGQ6I9c7SWafYmg2giR8Uwi7Ub_3m2H3ig9mpbqGpV89XxyUNChngzajvW SrunyFlwx7Vh.NRqOD1IXDVz1I2uIVtnuW6kSjWft3DdxezqAtQTtc8VfBExsI0wL6._zVhy5D6k 5ozT7dadzFt1p45O0IkiNXZXD9lYOzG2L.3O_RSDnuLDjXfqRkJfUQ4INg.R5lDQtNmf6_jbXe3b 7WwYk5DZZ22X6W49SU4HH9I2pot7FN5205uL5lT9M1ovrLAJusl6wOH_aZXZRiZ1k3raacTrcThr WPKacr1jQMue_1beFhr4Kng8TmldYBNnWxrLUKWODVg84pjUxddKJBIOQ7E1Koka1SIgpZ1zszwg oPOpP6x6D5h.qCDDlGs4Ee2ShTdSYQfHH8BGmrTBBoLwrUfZ1gFeW0J0HrcaygRg5hVSspfe8CHY gR9sgw7Digi24zswKVN5FuPpBu0M0bO70zIFKESsSgXJr1oqUlVu.gEOzv7KwDGIV7489EIaS1X2 a2.YDY9_LoDxJwQ.uzbNUIkZq0fmb.6oAlEWDeo9BjQsAlONM1IO14s5rXOHzVPfmX6wIRJPwgks 6ai_xxQx3_xOjOV4zKeOALq.efQll.yDzg4wIzDLTF7qvh9ZOWE2ZSBm_AEBYMfz2YVFI5wjTwiy 1dMXgTSSYrfOeTDwvw39EMRJesqr.ZWjyNcJ5f2kgngtmgS_6Wcm9t3ru.ZJ9on05mWde3gvHcfc delDsBSTyWquDy6qXI728XRfUiMNhZTycbj4jYZbYfeIH1GiE_qrowugkL8KnLAZxupqIua91jXb 2VOvCnbzt9XzKKAck0aZJTjI0sB6iLdAbXDTml9Lhb68Mr6yy1ST8e9cH2_zD1.3_jjP6ZwQxsMy c_V3KrlERbnF6G.NICTv7IT678YrlNWV4n1jdODg2ZF6NZtNuaPsmW9bDumWX1tP5saZrenGiI9f EYV09y3TE5PHoEMEaZtSHrUUS9tiDFThc_TmCBcGRAz9Rg25GvR5T1cYqDXFSIuBPUg0Wi_XUR0A pGUQz1MyolCoOXt5l7iCvO4JVr7nxygGV7lllOWkT.iTSfCmJNACEeM_jFEqTixkkWtR2Ksf61bR Am2xtELaAElTDMkhNUb1zUJC.k6PsG7IyDw_iCtZ.BIk4iXBLrtSLc5LXHOTWPOr.vXk7sNR0TIS NrKorpDrK9jjW1bupDQDcBJ4CMy886.x1DMYi8KZfSxuvXFsebcOa_5cel9wfEkkddqnSYrf7wxT Ekl9Y4486quNyRrcPu86S_6YIJVy2s6heFYjXhQZH0CNKeazgRK.yst8_NILwOF6VBnTCvQp6LdU oBAZjTAwLrE3gRRKR.1u6FoVY3qQ1voGntEfskRtS1IrDxEIme7NHR4kD233SLBzjZUCgOMMNV91 pvgW3mYUNntUwz1kSvyUGiht24QeaO4Ai0zyF0kF28QzCBlWd7SxYAG7IcjFcwN5m3bJ1aqrJnEi B8QiGgIUS8ZKZqpQvA7dYBHkoiNEwtLFab3AerNshoGg7xbxlpEu3rksBpgY_HZQ282TMDT2Kc2O DhKPXj9ntMAF0qkVl67T4fLxwfN9CEpvZ_K.vMZWOjhvhddOULc0qXfJjqB58OnAWfUfYbXTn5Uz NVutFRUT996_BcD.Ta0S3G7M69abacHXI91De38QjWio1zNxUA5UhQMEoN_gvIZdbq4J7Vubo8fi rcK.n2f7krWuBB4cfPHqJUqtHoJ4y1Xc7g2nWPdhvXGBYSmxDXIbO1IXb_1Mqlghg_wytN1sP.Bu LDFXd11ZDe948e1ILMhyOBXBl0WsyT9dxWVm8Ksh3_o8HpaNi_IzThXwnXDEr0cncLKuE2_DA62Z KSeZSCXM1Dw731hahwsFN7p_._OfZplvt776mhXmfYPg7CVcslmJj3z7.4yBhdWqENTwnP276r_9 H7yl_.lh1QiE4lcsUQBeRahhofXPG7GUte4KPD7r3wQfWsukvl8CXO9SSvWKRiSBJCcJCl3lUl9R IaWli4p4fcgsHKftlk_jTovft2XcwmmzWvGMQ46MNKCEiQb1Ob77s66_yII.k1NhpFOyuS1ewrK5 5uMdh7UXOH7qFlrJmqPniuYtLi4Qgn05x5dwMdw_JCoGh_wTeM0YSWgdWkH60KLwWTaIecLQ8MMw CQSZ9WXEIVnRmWKgM3gTgysM2tKR484_BoGkzGr0YPEG4Syd9MNDeYxL_DfT_0foSwpuaYPOgh5X UsNP5.Hkn6QtPDjIt_ftUVewVk_jnu7anHzfONav_Ecxuw97xCOktVJVoT1JzGwfxlChb2tFWsR9 eJRSiWEhnP_3C1CStRJt5JogwxyfjF4z1X8OXKQPIpN0cl38tS.M5hywl1teICUcMffnQFK.xrpp DlvA0qZ0L X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic308.consmr.mail.sg3.yahoo.com with HTTP; Sat, 3 Apr 2021 06:15:38 +0000 Date: Sat, 3 Apr 2021 06:15:37 +0000 (UTC) From: SASIKUMAR Devaraj To: "David G. Johnston" Cc: "Campbell, Lance" , Bruce Momjian , Laurenz Albe , MichaelDBA , "holger@jakobs.com" , "pgsql-admin@lists.postgresql.org" Message-ID: <1083971116.2431044.1617430537771@mail.yahoo.com> In-Reply-To: References: <04D84259-1B75-4648-949F-78677916194E@jakobs.com> <66290583.2329958.1617367063840@mail.yahoo.com> <1654783699.2333997.1617367552583@mail.yahoo.com> <592e5895-8dbd-1a4f-a87c-af72ac8eea02@sqlexec.com> <339e1ee870881a3efaffc7ea4cddac6bc4d009cf.camel@cybertec.at> <20210402150736.GD9270@momjian.us> <20210402153436.GE9270@momjian.us> <230367927.2421710.1617427436762@mail.yahoo.com> Subject: Re: work_mem MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2431043_642989038.1617430537769" X-Mailer: WebService/1.1.17936 YMailNorrin Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.75 Safari/537.36 Content-Length: 3132 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_2431043_642989038.1617430537769 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Excellent. Thank you very much for the clarification. Much Appreciated. Regards Sasi On Saturday, 3 April, 2021, 11:14:36 am IST, David G. Johnston wrote: =20 =20 =20 On Friday, April 2, 2021, SASIKUMAR Devaraj wrote: =20 Case 1:=C2=A0 work_mem=3D4mTotal Sessions connected=3D100Total=3D400M=C2=A0 Or Case 2work_mem=3D4mTotal Sort operations at DB now=3D50Total work_mem=3D= 200M Please clarify at high level whether Case 1 is true or Case 2 is true? Case 2 David J. =20 ------=_Part_2431043_642989038.1617430537769 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
Excellent. Thank you very much for the clarification. Much Appreciated.

Regards

Sasi

On Saturday, 3 April, 2021, 11:14:36 am IST, David G. Johnston <david.g.johnston@gmail.com> wrote:



On Friday, April 2, 2021, SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:

Case 1: 
work_mem=4m
Total Sessions connected=100
Total=400M 

Or Case 2
work_mem=4m
Total Sort operations at DB now=50
Total work_mem=200M

Please clarify at high level whether Case 1 is true or Case 2 is true?

Case 2

David J.
------=_Part_2431043_642989038.1617430537769--