Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tg5Tv-007cxf-Tv for pgsql-general@arkaria.postgresql.org; Thu, 06 Feb 2025 17:16:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tg5Tt-009au3-L6 for pgsql-general@arkaria.postgresql.org; Thu, 06 Feb 2025 17:16:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tg5Ts-009atq-3H for pgsql-general@lists.postgresql.org; Thu, 06 Feb 2025 17:16:01 +0000 Received: from fhigh-a7-smtp.messagingengine.com ([103.168.172.158]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tg5Tp-003ZIO-15 for pgsql-general@postgresql.org; Thu, 06 Feb 2025 17:15:59 +0000 Received: from phl-compute-05.internal (phl-compute-05.phl.internal [10.202.2.45]) by mailfhigh.phl.internal (Postfix) with ESMTP id 9BB57114021B; Thu, 6 Feb 2025 12:15:56 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-05.internal (MEProxy); Thu, 06 Feb 2025 12:15:56 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1738862156; x=1738948556; bh=ldec5ZZoYqmgnYpa4dwvFftdIW79Vt3zR37OQLiX274=; b= ZNCp/EFy4ixSMmPh+k+GWsI8QtEeEHetM11JEkjUM3gw4EGuaBEDWqsUAcAmGVSc HlTwNy1ezxYmBh5YzE2AUzmCgdA7QtqJ44qCDZ7TpVywpfBkCZvq3Fvrf+qZvFRD x5hb3TbwD15qsrxaNOsx9Pzl4So3cvGlZMILu9JXTuXd9QeZgDCLg1C5Lu7qag5C /qMW44AoIkrl24HH2VMdIF0omxI0Sg9WlL4mZcjM2WN1utXcamYoo5mhiGj56l2Q vTXqJVJzNSNemW2xETjQpHFuhE1G+oMJC673P0R1C5WomKlp31C51jHXWoQVFjf3 x50QQvOLdtzbcHffOGj9TA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1738862156; x= 1738948556; bh=ldec5ZZoYqmgnYpa4dwvFftdIW79Vt3zR37OQLiX274=; b=j OypOhfFLVtuyE2lI2/f8bc1c2vSiHimKbDMt5aTntQGGcRk8+VnCNdCQ7l6+mCAg lUj75oBMfOPiZ2toIafBcUUPBwoFvoiMqQQqTTJtbGPfAL1j1kLYa14mtxzKpIbA SLDOweLnXu5Lddgw/OBE+FWcw8kRkg2uksT0099tRaORF3F/qI1d/gy8B/o+owuQ 2YCgjUkcXrK8rE8HQvoAMkRagoNAQjX0io/M6I6tiFH0N/Wda/hqoVvG9QNWqKmx CsKCELm/76cX7WOO5crplbEw4dx2q30yraMkFvzaCgirFNjsAp8d0Y//I8JH2189 8gHiVQZ2ZYcXjXuIor40g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddvieelhecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpefkffggfgfuvfhfvefhjggtgfesthgsredttddv jeenucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvg hrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpefhgeekudetiedvfeei jeehhfdugfejleelveejvdehffehueevheefffejheejudenucevlhhushhtvghrufhiii gvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegr khhlrghvvghrrdgtohhmpdhnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpohhuth dprhgtphhtthhopehrlhgvrggthhesphhrihhntggvthhonhdrvgguuhdprhgtphhtthho pehpghhsqhhlqdhgvghnvghrrghlsehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 6 Feb 2025 12:15:55 -0500 (EST) Message-ID: <6d833658-f461-4ad4-a3e1-86d3c515bc18@aklaver.com> Date: Thu, 6 Feb 2025 09:15:55 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: How to perform a long running dry run transaction without blocking To: Robert Leach References: <88d60ace-45e6-4d41-afc4-113df7219c4d@aklaver.com> <4000D0EE-B250-4E9E-831F-00C034D6D0B5@princeton.edu> Content-Language: en-US Cc: pgsql-general From: Adrian Klaver In-Reply-To: <4000D0EE-B250-4E9E-831F-00C034D6D0B5@princeton.edu> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gMi82LzI1IDA4OjUzLCBSb2JlcnQgTGVhY2ggd3JvdGU6DQo+IEdyZWF0IHF1ZXN0aW9u cyEgIFJlc3BvbnNlcyBpbmxpbmUuLi4NCg0KUGxlYXNlIHJlcGx5IHRvIGxpc3QgYWxzby4N CkNjaW5nIGxpc3QNCg0KPj4gTG9hZCB0byB3aGVyZSBleGlzdGluZyB0YWJsZSBvciB0ZW1w b3JhcnkgdGFibGU/DQo+IA0KPiBFeGlzdGluZyB0YWJsZXMuICBOb3RlIHRoYXQgKGFuZCB0 aGlzIGlzIGEgcG9pbnQgb2YgY29udGVudGlvbiBpbiBvdXIgdGVhbSksIHdlIGhhdmUgc29t ZSBmaWVsZHMgdGhhdCBtdXN0IGJlIHVuaXZlcnNhbGx5IHVuaXF1ZSBhY3Jvc3MgYWxsIHN0 dWR5IGRhdGEsIHNvIGlmIHdlIHdlcmUgdG8gZW1wbG95IHRlbXBvcmFyeSAoZW1wdHkpIHRh Ymxlcywgd2Ugd291bGQgbWlzcyBvdXQgb24gdGhlIHVuaXF1ZW5lc3MgY2hlY2tzLg0KDQpU aGF0IGlzIGFub3RoZXIgZGlzY3Vzc2lvbi4NCg0KPiANCj4gQmFja2dyb3VuZDogVGhlIHBy ZXZpb3VzIHNvbHV0aW9uIGZvciB0aGlzIHZhbGlkYXRpb24gaW50ZXJmYWNlIHRoYXQgSSBo YWQgdHJpZWQsIHVzZWQgYSBwYXJ0aWFsIGNvcHkgb2YgdGhlIGRhdGFiYXNlIHdoaWNoIEkg Y2FsbGVkIHRoZSAidmFsaWRhdGlvbiIgZGF0YWJhc2UuICAoSSdkIGJlZW4gZm9yY2VkIHRv IGRvIGl0IHRoYXQgd2F5IGJlY2F1c2UgcHJldmlvdXMgZGV2ZWxvcGVycyBoYWRuJ3QgdXNl ZCB0cmFuc2FjdGlvbnMgYW5kIHRoZWlyICJkcnkgcnVuIiBtb2RlIGhhZCBzaWRlIGVmZmVj dHMgdGhhdCBJIGRpZG4ndCB3YW50IHRvIGhhcHBlbiBkdWUgdG8gdGhlIHZhbGlkYXRpb24g aW50ZXJmYWNlLCBzbyBpbnN0ZWFkIG9mIGVuZ2FnZSBpbiBhIG1hc3NpdmUgcmVmYWN0b3Is IEkgdHJpZWQgdXNpbmcgYSBzZXBhcmF0ZSBkYXRhYmFzZSBhcyBhIHF1aWNrIHRlbXBvcmFy eSBmaXguKSAgQnV0IG1pbmQgeW91LCBhbGwgb2YgdGhlIGNvZGUgSSB3YXMgd3JpdGluZyB3 YXMgaW4gZGphbmdvIChweXRob24pLCBhbmQgaW4gb3JkZXIgdG8gbWFpbnRhaW4gMiBkaWZm ZXJlbnQgZGF0YWJhc2VzIGFuZCBzdGF5IGRhdGFiYXNlIGFyY2hpdGVjdHVyZSBhZ25vc3Rp YywgSSBsZWFybmVkIHRoYXQgeW91ciBjb2RlIG11c3QgYmUgbGl0dGVyZWQgd2l0aCBodW5k cmVkcyBvZiBpbnNlcnRpb25zIG9mIGAudXNpbmcoKWAgKGFuZCBvdGhlcikgc3RhdGVtZW50 cywgYW5kIGl0IHR1cm5lZCBvdXQgdGhhdCB0aGF0IHN0cmF0ZWd5IGlzIG5vdCAxMDAlIGNv bXBhdGlibGUgd2l0aCBldmVyeSBraW5kIG9mIERqYW5nbyBPUk0gdGhpbmcgeW91IGNhbiBk byAoZS5nLiBgZnVsbF9jbGVhbigpYCksIHNvIEknZCBoYWQgdG8gZGlnIGFyb3VuZCBpbiBk amFuZ28gY29yZSBjb2RlIHRvIGVuc3VyZSBldmVyeSBvcGVyYXRpb24gd2FzIGJlaW5nIHBl cmZvcm1lZCBvbiB0aGUgY29ycmVjdCBkYXRhYmFzZS4gIEl0IHdhcyBhIG5pZ2h0bWFyZSB0 byBtYWludGFpbiBhbmQgSSBoYXBwaWx5IHJpcHBlZCBpdCBhbGwgb3V0IHdoZW4gSSBjb3Jy ZWN0ZWQgdGhlIG9yaWdpbmFsIHByb2JsZW1zIGJ5IHdyYXBwaW5nIGV2ZXJ5dGhpbmcgaW4g YSB0cmFuc2FjdGlvbi4NCg0KWWVhaCwgcmVhc29uIHdoeSBJIGJ5cGFzcyB0aGUgT1JNLg0K DQo+IA0KPj4+IFRoaXMgdmFsaWRhdGlvbiBpbnRlcmZhY2Ugc2tpcHMgdGhlIHJhdyBkYXRh IGxvYWQgc3RlcCwgd2hpY2ggaXMgdGhlIGhlZnRpZXN0LCBtb3N0IGxvbmcgcnVubmluZywg cGFydCBhbmQgZ2VuZXJhbGx5IGZpbmlzaGVzIGluIHdlbGwgdW5kZXIgYSBtaW51dGUuDQo+ Pg0KPj4gU28gd2hhdCBpcyB0aGUgdmFsaWRhdGlvbiBhY3R1YWxseSBkb2luZz8NCj4gDQo+ IFRoZSByYXcgZGF0YSBpcyBwcmV0dHkgc29saWQuICBJdCBpcyBhdXRvbWF0aWNhbGx5IGdl bmVyYXRlZCBieSBoYXJkd2FyZSAobWFzcyBzcGVjdHJvbWV0ZXIpIGFuZCBzb2Z0d2FyZSAo cGVhayBhbmFseXNpcyBzdWl0ZXMpLiAgU28gaXQgZG9lc24ndCBuZWVkIG11Y2ggKGlmIGFu eSkgdmFsaWRhdGlvbi4gIFdoYXQgbmVlZHMgdmFsaWRhdGlvbiBpcyBhbGwgdGhlIG1ldGFk YXRhIGFzc29jaWF0ZWQgd2l0aCB0aGUgc2FtcGxlcyB0aGF0IGlzIHRvdGFsbHkgZ2VuZXJh dGVkIGJ5IGhhbmQgYnkgdGhlIHJlc2VhcmNoZXJzLg0KPiANCj4gVGhleSBlbnRlciB0aGUg ZGF0YSBpbiBhbiBleGNlbCBzcHJlYWRzaGVldCBjb250YWluaW5nIGFib3V0IGEgZG96ZW4g aW50ZXItcmVsYXRlZCB3b3Jrc2hlZXRzLCBuYW1lZCwgZm9yIGV4YW1wbGU6IFN0dWR5LCBB bmltYWxzLCBTYW1wbGVzLCBUaXNzdWVzLCBUcmVhdG1lbnRzLCBTZXF1ZW5jZXMgDQoNCldl bGwgdGhlcmUncyB5b3VyIHByb2JsZW06KSBJIHdpbGwgc3BhcmUgeW91IG15IGZ1bGwgc3By ZWFkc2hlZXQgcmFudC4NCg0KTG9uZyB0ZXJtIGlzIHRoZXJlIGEgdGhvdWdodCB0byBoYXZl IHRoZW0gZW50ZXIgZGlyZWN0bHkgaW50byBkYXRhYmFzZSANCndoZXJlIHZhbGlkYXRpb24g Y2FuIGhhcHBlbiBpbiByZWFsIHRpbWUNCg0KPj4gV2hlcmUgYXJlIHRoZSBiYWNrZ3JvdW5k IHByb2Nlc3NlcyBsb2FkaW5nIGRhdGEgdG8/DQo+IA0KPiBXZSBmaXJzdCBydW4gb3VyIGxv YWRzIG9uIGEgZGV2ZWxvcG1lbnQgc2VydmVyIHdpdGggYSBzZXBhcmF0ZSBjb3B5IG9mIHRo ZSBkYXRhYmFzZSwgYnV0IHRoZW4gd2UgcmUtcnVuIHRob3NlIHNhbWUgbG9hZHMgb24gdGhl IHByb2R1Y3Rpb24gc2VydmVyLCB3aGVyZSB1c2VycyBwZXJmb3JtIHRoZWlyIHZhbGlkYXRp b25zLg0KDQpUaGUgbG9hZCB0byB0aGUgZGV2ZWxvcG1lbnQgc2VydmVyIGRvZXMgbm8gdmFs aWRhdGlvbj8NCg0KSWYgc28gd2hhdCBpcyB0aGUgcHVycG9zZT8NCg0KVGhlIGJhY2tncm91 bmQgcHJvY2Vzc2VzIGFyZSBvdGhlciB2YWxpZGF0aW9uIHJ1bnM/DQoNCj4gDQo+IE9uZSBv ZiB0aGUgdGhvdWdodHMgSSdkIGhhZCB0byB3b3JrIGFyb3VuZCB0aGUgcHJvYmxlbSB3YXMg dG8gc29tZWhvdyBkdW1wIHRoZSBkYXRhIGZyb20gdGhlIGRldmVsb3BtZW50IGxvYWQgYW5k IGxvYWQgaXQgb250byBwcm9kdWN0aW9uIGluIHNvbWUgc29ydCBvZiBzY2hlZHVsZWQgZG93 bnRpbWUgb3Igc29tZXRoaW5nLiAgSG93ZXZlciwgZXZlbiBpZiB3ZSBkbyB0aGF0LCBJJ20g Y29uY2VybmVkIHRoYXQgbXVsdGlwbGUgdXNlcnMgY29uY3VycmVudGx5IHZhbGlkYXRpbmcg ZGlmZmVyZW50IHN1Ym1pc3Npb25zIHdvdWxkIGVuY291bnRlciB0aGlzIGJsb2NraW5nIGlz c3VlLCBhbmQgc2luY2UgdGhvc2UgdmFsaWRhdGlvbnMgY2FuIHRha2UgKG9uIHRoZSB1cHBl ciBlbmQpIGp1c3QgdW5kZXIgYSBtaW51dGUsIGl0J3MgZW5vdWdoIGZvciBhdCBsZWFzdCAx IHVzZXIgdG8gZW5jb3VudGVyIGEgdGltZW91dC4gIEkgaGF2ZSBub3QgeWV0IHByb3ZlbiB0 aGF0IGNhbiBoYXBwZW4sIGJ1dCBiYXNlZCBvbiBteSByZWFkaW5nIG9mIHRoZSBwb3N0Z3Jl cyBkb2N1bWVudGF0aW9uLCBpdCBzZWVtcyBsb2dpY2FsLg0KPiANCg0KU2VlbXMgeW91IGFy ZSBsb29raW5nIGZvciBzb21lIHNvcnQgb2YgcXVldWluZyBzeXN0ZW0uDQoNCldoYXQgYXJl IHRoZSB0aW1lIGNvbnN0cmFpbnRzIGZvciBnZXR0aW5nIHRoZSB2YWxpZGF0aW9uIHR1cm5l ZCBhcm91bmQuDQoNCg0KPj4gTm90IHRoYXQgSSBrbm93IG9mIGFuZCB0aGF0IHdvdWxkIGJl IGEgZmFsc2UgcHJvbWlzZSBhbnl3YXkgYXMgSSBrbm93IG9mIG5vIHByb2Nlc3MgdGhhdCBp cyBwZXJmZWN0Lg0KPiANCj4gSSByZWFsaXplIHRoYXQgaXQncyBhIGZhbHNlIHByb21pc2Ug V1JUIHRoZSBiYWNrZ3JvdW5kIGxvYWQgdHJhbnNhY3Rpb24sIGJ1dCBpdCdzIGEgbW9vdCBj b25jZXJuIGZyb20gdGhlIHBlcnNwZWN0aXZlIG9mIHRoZSB2YWxpZGF0aW9uIHBhZ2UsIGJl Y2F1c2UgaXQgaXMgbWFraW5nIGEgZ3VhcmFudGVlZCBwcm9taXNlIHRoYXQgaXQgd2lsbCBu ZXZlciBjb21taXQuICBBbGwgSSB3YW50IGlzIGZvciBpdCB0byBub3QgYmUgYmxvY2tlZCBz byBJIGNhbiByZXBvcnQgYXMgbWFueSBlcnJvcnMgYXMgSSBjYW4gdG8gdGhlIHJlc2VhcmNo ZXIgc28gdGhleSBjYW4gYWR2YW5jZSB0aGVpciBzdWJtaXNzaW9uIGNvbXBpbGF0aW9uLiAg YmVzaWRlcywgdGhlcmUncyBhIHByZXR0eSBzb2xpZCBiZXQgdGhhdCBzaW5jZSB0aGUgbG9h ZCBzdWNjZWVkZWQgb24gdGhlIGRldmVsb3BtZW50IHNlcnZlciwgaXQgd2lsbCBzdWNjZWVk IG9uIHRoZSBwcm9kdWN0aW9uIHNlcnZlciB3aGVyZSB0aGlzIGJsb2NrIHdvdWxkIGhhcHBl bi4NCj4gDQo+IFNvIGlmIHRoZSBsb2FkIHRyYW5zYWN0aW9uIGRvZXMgZmFpbCwgYW5kIHRo ZSBkYXRhIHRoZSB2YWxpZGF0aW9uIHByb2Nlc3Mgd2FzIHdhaXRpbmcgb24gKHRvIHNlZSB0 aGUgb3V0Y29tZSkgaXMgbm90IHJlcG9ydGVkIGFzIHByb2JsZW1hdGljIHRvIHRoZSB1c2Vy LCBpdCB3aWxsIGJlIHJlcG9ydGVkIGFzIHByb2JsZW1hdGljIHRvIHRob3NlIHJlc3BvbnNp YmxlIGZvciB0aGUgbG9hZCBvbiB0aGUgYmFjay1lbmQsIHNvIGl0IGdldHMgZGVhbHQgd2l0 aCBlaXRoZXIgd2F5Lg0KPiANCg0KPj4NCj4+IC0tIA0KPj4gQWRyaWFuIEtsYXZlcg0KPj4g YWRyaWFuLmtsYXZlckBha2xhdmVyLmNvbQ0KPiANCj4gDQo+IA0KPiBSb2JlcnQgV2lsbGlh bSBMZWFjaA0KPiBSZXNlYXJjaCBTb2Z0d2FyZSBFbmdpbmVlcg0KPiAxMzMgQ2FybCBDLiBJ Y2FobiBMYWINCj4gTGV3aXMtU2lnbGVyIEluc3RpdHV0ZSBmb3IgSW50ZWdyYXRpdmUgR2Vu b21pY3MNCj4gUHJpbmNldG9uIFVuaXZlcnNpdHkNCj4gUHJpbmNldG9uLCBOSiAwODU0NA0K PiANCg0KLS0gDQpBZHJpYW4gS2xhdmVyDQphZHJpYW4ua2xhdmVyQGFrbGF2ZXIuY29tDQoN Cg==