Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ejXkY-0006hI-7i for pgsql-hackers@arkaria.postgresql.org; Wed, 07 Feb 2018 21:59:30 +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 1ejXkW-0005gu-VQ for pgsql-hackers@arkaria.postgresql.org; Wed, 07 Feb 2018 21:59:28 +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 1ejXkW-0005gk-Kr for pgsql-hackers@lists.postgresql.org; Wed, 07 Feb 2018 21:59:28 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ejXkU-0004U3-1e for pgsql-hackers@postgresql.org; Wed, 07 Feb 2018 21:59:27 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id w17LxK4b003247; Wed, 7 Feb 2018 16:59:20 -0500 From: Tom Lane To: Robert Haas cc: Kyotaro HORIGUCHI , Sawada Masahiko , Michael Paquier , "pgsql-hackers@postgresql.org" Subject: Re: [HACKERS] More stats about skipped vacuums In-reply-to: References: <20171211.201523.24172046.horiguchi.kyotaro@lab.ntt.co.jp> <20180206.192437.229464841.horiguchi.kyotaro@lab.ntt.co.jp> <20180207.103458.192443145.horiguchi.kyotaro@lab.ntt.co.jp> Comments: In-reply-to Robert Haas message dated "Wed, 07 Feb 2018 12:09:26 -0500" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <3245.1518040760.1@sss.pgh.pa.us> Date: Wed, 07 Feb 2018 16:59:20 -0500 Message-ID: <3246.1518040760@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Robert Haas writes: > It seems to me that there was a thread where Tom proposed removing > support for dynamic_shared_memory_type = none. I think you're recalling <32138.1502675970@sss.pgh.pa.us>, wherein I pointed out that >>> Whether that's worth the trouble is debatable. The current code >>> in initdb believes that every platform has some type of DSM support >>> (see choose_dsm_implementation). Nobody's complained about that, >>> and it certainly works on every buildfarm animal. So for all we know, >>> dynamic_shared_memory_type = none is broken already. (That was in fact in the same thread Kyotaro-san just linked to about reimplementing the stats collector.) It's still true that we've no reason to believe there are any supported platforms that haven't got some sort of DSM. Performance might be a different question, of course ... but it's hard to believe that transferring stats through DSM wouldn't be better than writing them out to files. > I suggest we remove support for dynamic_shared_memory_type = none first, > and see if we get any complaints. If we don't, then future patches can > rely on it being present. If we remove it in v11, it'd still be maybe a year from now before we'd have much confidence from that alone that nobody cares. I think the lack of complaints about it in 9.6 and 10 is a more useful data point. regards, tom lane