Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ea7Ss-0001uH-2f for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Jan 2018 22:06:18 +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 1ea7Sr-0002bX-Ht for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Jan 2018 22:06:17 +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 1ea7Sr-0002bI-8h; Fri, 12 Jan 2018 22:06:17 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ea7So-0006rg-So; Fri, 12 Jan 2018 22:06:16 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 18BBE2100A; Fri, 12 Jan 2018 17:06:14 -0500 (EST) Received: from frontend1 ([10.202.2.160]) by compute5.internal (MEProxy); Fri, 12 Jan 2018 17:06:14 -0500 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; s=fm1; bh=MRCspnw8kucwHEjAwCL5jwURdQpaO yhu4f9Cmxp55oo=; b=KsNvNCAFrvU7wKCl/1C01YCjjcMFrQez802CWw44j9afB K8m/ormLyxXLO4Pv3gbH+YtTQg8ZjgGaZecYZ7TyXLzeebqI61GoO56MtfD/EeQ4 tvMlYarjRDhDrOeWD8LEyologDAP+xSQoDk61ab6Tq2rAlh/vs/pL4GVvPmLt0zZ nh3FNYtW14LC06yUoJDFK2Xx9vQFhswL8/X9ggKIASm2mF6jTPzgsz0LhMQpxhrj 9GMIjdvkfk8IlTOpizWVgho9xNXon3MdlfAQjflueiIKnF/WKDXPNZ06eeS8u4JC 62jVmgQW3+8aApB6ah26ShJHDBwBLsPst7Rd/nrbw== X-ME-Sender: Received: from intern.anarazel.de (unknown [136.24.76.189]) by mail.messagingengine.com (Postfix) with ESMTPA id B2BC57E34D; Fri, 12 Jan 2018 17:06:13 -0500 (EST) Date: Fri, 12 Jan 2018 14:06:12 -0800 From: Andres Freund To: Robert Haas Cc: Thomas Munro , Andrew Dunstan , Tom Lane , Stephen Frost , Bruce Momjian , "David E. Wheeler" , Christophe Pettus , Postgres-Bugs , "pgsql-hackers@postgresql.org" Subject: Re: [HACKERS] [BUGS] BUG #14825: enum type: unsafe use? Message-ID: <20180112220612.jvblkkumiifb5355@alap3.anarazel.de> References: <5161729c-4597-8a41-f4e2-c7d97e84d86e@2ndQuadrant.com> <32160eb9-60df-746b-bbc0-dd232b993d6d@2ndQuadrant.com> <10135.1506538374@sss.pgh.pa.us> <20171004013856.2xzd2nw6oufbbtms@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2018-01-12 07:51:34 -0500, Robert Haas wrote: > On Thu, Jan 11, 2018 at 11:01 PM, Thomas Munro > wrote: > > Are you saying we should do the work now to create a per-transaction > > DSM segment + DSA area + thing that every backend attaches to? > > No, I was just thinking you could stuff it into the per-parallel-query > DSM/DSA. But... > > > I didn't think creating backend local hash tables would be a problem > > because it's a vanishingly rare occurrence for the hash table to be > > created at all (ie when you've altered an enum), and if created, to > > have more than a couple of entries in it. > > ...this is also a fair point. OTOH, it seems quite likely that we'll add more transaction-lifetime shared data (e.g. combocid), so building per-xact infrastructure actually seems like a good idea. Greetings, Andres Freund