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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tg70d-007oOT-TX
	for pgsql-general@arkaria.postgresql.org; Thu, 06 Feb 2025 18:53:56 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tg70c-00ASiZ-Cl
	for pgsql-general@arkaria.postgresql.org; Thu, 06 Feb 2025 18:53:54 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <robjsargent@gmail.com>)
	id 1tg70c-00ASiQ-27
	for pgsql-general@lists.postgresql.org; Thu, 06 Feb 2025 18:53:54 +0000
Received: from mail-pl1-x635.google.com ([2607:f8b0:4864:20::635])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <robjsargent@gmail.com>)
	id 1tg70Z-004412-17
	for pgsql-general@postgresql.org;
	Thu, 06 Feb 2025 18:53:53 +0000
Received: by mail-pl1-x635.google.com with SMTP id d9443c01a7336-21f49bd087cso8329515ad.0
        for <pgsql-general@postgresql.org>; Thu, 06 Feb 2025 10:53:51 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1738868029; x=1739472829; darn=postgresql.org;
        h=to:in-reply-to:cc:references:message-id:date:subject:mime-version
         :from:content-transfer-encoding:from:to:cc:subject:date:message-id
         :reply-to;
        bh=0karLUUFMjfqO1pvxIdwFNQOtIAGntg13iJ09pI0imc=;
        b=J4gBvmzjbrdRQKV/SjKwquECatLPzFQF8X5VV6d/IgHt/jpIMfmx9HeoMPwbJQt4Wq
         H4FibT5LsEZgK65w2fMbXcrqhTc/s9fIs5RxlO5jnfUqnH9b6oWEPW06aGSs9cjTqrm+
         Sn+U8VQEo2ooLNuOg+N8P6rA4YpPHlyVZpqE7+X2in6JLRfdr/MG5CxzCgZOAxa41sRW
         N94BwVDlbCOcb6dwjTI6UTqqlskWjkEatKkokL2Oos82SLFIIvaz73lWgzpaxbwcraD3
         b2VKVQWowpiEFYPUN2fWnlvxndbBRWrRhhIWXS4r6DObZ9JUAcC9Z23xJvtdaXWK0AyQ
         zDdA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1738868029; x=1739472829;
        h=to:in-reply-to:cc:references:message-id:date:subject:mime-version
         :from:content-transfer-encoding:x-gm-message-state:from:to:cc
         :subject:date:message-id:reply-to;
        bh=0karLUUFMjfqO1pvxIdwFNQOtIAGntg13iJ09pI0imc=;
        b=Xw+YOVed9GAAhMyPjGGnBMtTuQDIld5uYPuMa9zrwK9U6kxtzn1ASNgVVN259rkEw1
         l6rv240Xhp8Su/8damT4nI56reqx+ubmreKiqsh73IzySPFz0uMyD9yozoajAH61l0Z1
         NLnwfHAhae6sDIhgq/pHXPWeLVmMBY2k3SKTx/o6J3gMNpUMaeHUUmZT+WO28YyQt8vK
         UxfIhEQhIB8MXIbNwyRRcu84TmzcBzKyV6ouC9Xgg9VhR49AUjyTZ/Dsk9AmMsuentaO
         lfLUGXY2OuKprqhTnpaLd/UQWNLhgKMCxrc/8Xv8rA+x70LmM0dZO0KubdIo77mhk0sq
         C66A==
X-Forwarded-Encrypted: i=1; AJvYcCWJpRuzgmkqrdPnD2muY2XG59TaWlYdO67kdEgiiBySQR5VlQJpfkEmkdI0Nvyeks6uTuB6P7r15pu53zQ0@postgresql.org
X-Gm-Message-State: AOJu0YxSCSybOlIRmSkTliV06tz58lYSAqUObG5CajGm8nkCj/OoO6Rk
	a1DWNGxF2ImoRswNu4LvnJ//7vcO+csXxji5QYdStQK9fE4GqS0/
X-Gm-Gg: ASbGncshqYqd9B5uqhsMUy1Nt4oWZ5GqPGDIJji931TbRxQDVWvtA+c4f9J8yHKNIc5
	FIusjBGNvEwXPLfViEoahul5PDlevgGSdw3Y4Cx5pZ+Bjulqdnirz6T5FOaC3CBeOYwenb/Aeug
	C6E7N2VXy660VnCPAxHNweXQCjSt+ArBSyrMYkJ0RtTpSmyNVLJpyHfgrCSxynbuKDwi1xkXak5
	9fGdzbhamHec/asm87ezbN9GD/6j4s+ptJn/H57+aehs4d1z+R0M2GCTn8nqxzdVBRJtawMceuZ
	wFqZ/DmuCLN2pAnlFuo6tRl+WqEJlF9QY3H0x7aBcJs=
X-Google-Smtp-Source: AGHT+IEIWMlsWvGuip9iUzTyLMSf1nZ5JUUL6dRtcQxMAYNlqTuHiLvZr8bB5IM9mLsUkf7qhjyzpA==
X-Received: by 2002:a17:902:db07:b0:216:6855:15f with SMTP id d9443c01a7336-21f4e764d2dmr3302485ad.51.1738868029454;
        Thu, 06 Feb 2025 10:53:49 -0800 (PST)
Received: from smtpclient.apple ([2601:681:4c01:7310:d4bc:1730:7ba1:840])
        by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-ad51aee7fbasm1664065a12.46.2025.02.06.10.53.48
        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
        Thu, 06 Feb 2025 10:53:49 -0800 (PST)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
From: Rob Sargent <robjsargent@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: How to perform a long running dry run transaction without blocking
Date: Thu, 6 Feb 2025 11:53:38 -0700
Message-Id: <798DA50B-7932-4CF5-A16F-9131881EDDF6@gmail.com>
References: <0FE9C709-A108-4ED5-8132-B802B8D9908F@princeton.edu>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>,
 pgsql-general <pgsql-general@postgresql.org>
In-Reply-To: <0FE9C709-A108-4ED5-8132-B802B8D9908F@princeton.edu>
To: Robert Leach <rleach@princeton.edu>
X-Mailer: iPhone Mail (22C161)
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/798DA50B-7932-4CF5-A16F-9131881EDDF6%40gmail.com>
Precedence: bulk


>=20
Have you considered a validation app? Have it read the inputs and look in db=
 for conflicts, rather than attempt the insert. Zero transactions necessary=20=