Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dhING-0000c7-5N for pgsql-hackers@arkaria.postgresql.org; Mon, 14 Aug 2017 16:37:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dhINF-0004vK-OC for pgsql-hackers@arkaria.postgresql.org; Mon, 14 Aug 2017 16:37:53 +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 1dhILh-0007Fm-FY for pgsql-hackers@postgresql.org; Mon, 14 Aug 2017 16:36:17 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dhILd-0003GZ-Pd for pgsql-hackers@postgresql.org; Mon, 14 Aug 2017 16:36:16 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 94E3820AA5; Mon, 14 Aug 2017 12:36:12 -0400 (EDT) Received: from frontend2 ([10.202.2.161]) by compute5.internal (MEProxy); Mon, 14 Aug 2017 12:36:12 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc:x-sasl-enc; s=fm1; bh=/9dzC1vWyhAH5ABkhm /jf7ePgEX2tssHbPp/xk6RfWU=; b=sEIQmQs7dcKZLO+SN/BF5J/WxKbqVYuVzS +VkQbT5IQS4y0+CQjWdiULzhao2DqPDOqoYAcyM1raJzcfqtevHuHDAGQJo/AcGz AzWW9a0aH2AWZZaxWmEUR3nZpKMjwBUeLuiYNYX0xoryK6JBep/bHMPHNMD9f3I+ 0v3H05TmKQgteKaZXxhP0oPtC5qc75K833hEUIm4Pn1QwHUweVKPQjclLZbVOE4F PSboXOsweV2mTN6Obdy5cAzJkv3iBAvDwClGVdQ+Di4dr4cDax/m3Cwd1e/jtWc8 uF98UozLVCrZfXO0CnSbJVpFEITDyHdSW2XmaPNk9P7OFNKCdsqQ== X-ME-Sender: X-Sasl-enc: MSUnzhyZATEQVhh1zZBz0XHzQq7hHyfOfk9dCKHPbCbi 1502728572 Received: from intern.anarazel.de (unknown [136.24.76.72]) by mail.messagingengine.com (Postfix) with ESMTPA id 278D0247AB; Mon, 14 Aug 2017 12:36:12 -0400 (EDT) Date: Mon, 14 Aug 2017 09:36:10 -0700 From: Andres Freund To: Tom Lane Cc: Robert Haas , Alvaro Herrera , Thomas Munro , Dilip Kumar , Pg Hackers Subject: Re: shared memory based stat collector (was: Sharing record typmods between backends) Message-ID: <20170814163610.pgdzwygma2q6csi6@alap3.anarazel.de> References: <20170814005656.d5tvz464qkmz66tq@alap3.anarazel.de> <32138.1502675970@sss.pgh.pa.us> <9714.1502727365@sss.pgh.pa.us> <10227.1502728119@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <10227.1502728119@sss.pgh.pa.us> List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 2017-08-14 12:28:39 -0400, Tom Lane wrote: > Robert Haas writes: > > On Mon, Aug 14, 2017 at 12:16 PM, Tom Lane wrote: > >> Just FYI, the only values being reported by buildfarm animals are > >> "posix", "sysv", and "windows". So while mmap may be a thing, > >> it's an untested thing. > > > I'm pretty sure I dev-tested it before committing anything, but, > > certainly, having ongoing BF coverage woudn't be a bad thing. > > Looking closer, the reason those are the only reported values is > that those are the only possible results from initdb's > choose_dsm_implementation(). So the real question here is whether > "mmap" should be considered to dominate "sysv" if it's available. No mmap isn't a good option - it's file backed mmap, rather than anonymous mmap. To my knowledge there's no good portable way to use anonymous mmap to share memory across processes unless established before a fork(). > If so, why isn't choose_dsm_implementation() trying it; and if not, > why are we carrying it? I think the idea was that there might be platforms that require it, but ... Greetings, Andres Freund -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers