Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iFi6d-0003WT-RP for pgsql-committers@arkaria.postgresql.org; Wed, 02 Oct 2019 17:08:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iFi6c-0003Ey-5W for pgsql-committers@arkaria.postgresql.org; Wed, 02 Oct 2019 17:08:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iFi6a-0003El-De for pgsql-committers@lists.postgresql.org; Wed, 02 Oct 2019 17:08:02 +0000 Received: from [66.111.4.25] (helo=out1-smtp.messagingengine.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iFi6T-0004Ge-95 for pgsql-committers@lists.postgresql.org; Wed, 02 Oct 2019 17:07:59 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 39FF7222CE; Wed, 2 Oct 2019 13:07:42 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Wed, 02 Oct 2019 13:07:42 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=0wTO4AfhS+wRoZhfYq5qV1A7whQ MRsm2mfrOTJBlq+s=; b=jqSm4Pz/5V52JOU/Yf77YsCp+fTmhfxlWM+FJfG1qPj q60EeJZDPNh8RUTYc4hqm8VmZjT31ccHdlxwupbE+A4v+yDH5V0m7Ywx4WK9/N3Z 8FlnTZEK5YM/xeWzqdETWkSnBSltYOymhkW88lP98wkCMzdeqfvWLIdfRL6r0YH1 airrR1yqU+siQWYXNvzSAKmzv8IeAh9t3sCFL72O/LRA3SIZ2iNwowKNoB8KMBaX 0bs2Q8Z0IPkYjCji9dLdvitmrX9oyTx1vrYewEngeyD7RePWY+Y+5DM5wBA24s2X RIwJUJgmvyefCW/Pg8y6qK/ZM+R+Gp1L/5U7L79dqOQ== 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-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=0wTO4A fhS+wRoZhfYq5qV1A7whQMRsm2mfrOTJBlq+s=; b=Q6nbOfCL9YMM8AmRS1t2Yw Hpaz7cer0g1pIaFjkblsgmYbeF3hWd/mBx/mUxsAf+CvnpeojzsyZGGrpsOaNc0w flwPuxgWRBgtMRWmoz4d18jh05S64uroA6JHkoONaujjbpm8A4Y51OZHwP/Yw0Ch rhuWEM4SnLl+aUiFm/zpBDVJJVecH01idAxkQMd6RYI6E4F32DIt/QY2wIb/Tcev lUwHCAEa3ZpTBy6ji3p42tiwAFiFk6o9LMsDBPIMAZ7L36wp3XBSa0UocsUdH6Xx eRTp4C8757kyw0XkTDuUXL0Kjv2UK99P2uPuQj22P5Ez1BXMECk2CvCHUseP2gaA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrgeeigddutdekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvuffkfhggtggujgesthdtredttddt vdenucfhrhhomheptehnughrvghsucfhrhgvuhhnugcuoegrnhgurhgvshesrghnrghrrg iivghlrdguvgeqnecukfhppeeijedrudeitddrvddukedrvdefjeenucfrrghrrghmpehm rghilhhfrhhomheprghnughrvghssegrnhgrrhgriigvlhdruggvnecuvehluhhsthgvrh fuihiivgeptd X-ME-Proxy: Received: from intern.anarazel.de (c-67-160-218-237.hsd1.ca.comcast.net [67.160.218.237]) by mail.messagingengine.com (Postfix) with ESMTPA id BB5E4D60062; Wed, 2 Oct 2019 13:07:41 -0400 (EDT) Date: Wed, 2 Oct 2019 10:07:40 -0700 From: Andres Freund To: Fujii Masao Cc: Michael Paquier , Tom Lane , pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Add hooks for session start and session end, take two Message-ID: <20191002170740.ldzmr23b5zfgxnxk@alap3.anarazel.de> References: <20191001045246.GF2781@paquier.xyz> <18722.1569906636@sss.pgh.pa.us> <20191001052543.GI2781@paquier.xyz> <20191002000228.i2vcd4maxy3nl3vp@alap3.anarazel.de> <20191002002558.GB3130@paquier.xyz> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Host-Lookup-Failed: Reverse DNS lookup failed for 66.111.4.25 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, On 2019-10-02 13:27:50 +0900, Fujii Masao wrote: > On Wed, Oct 2, 2019 at 9:26 AM Michael Paquier wrote: > > > > On Tue, Oct 01, 2019 at 05:02:28PM -0700, Andres Freund wrote: > > > The reason for that is simply that at that point llvmjit.c's own > > > shutdown hook has already shutdown parts of the JIT subsystem (which > > > needs to flush profiling information to disk, for profiling to be > > > useful). > > > > Hmm. I missed the actual point. The current location for the session > > end hook has been chosen because we are sure that any transaction has > > been aborted properly, and we'd still be limited with a hook in > > proc_exit_prepare() because of that same argument. I am just going to > > revert the patch. > > If only session end hook is problematic, you will commit session start > hook again? My impression is that these patches first need considerably more actual design and code review. This wasn't a subtle issue or anything. Greetings, Andres Freund