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 1t7zSN-001Neu-8Q for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Nov 2024 15:57:30 +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 1t7zSK-002g3i-IR for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Nov 2024 15:57:29 +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 ) id 1t7zSK-002g3a-54 for pgsql-hackers@lists.postgresql.org; Mon, 04 Nov 2024 15:57:28 +0000 Received: from meesny.iki.fi ([195.140.195.201]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t7zSD-000AE0-7t for pgsql-hackers@postgresql.org; Mon, 04 Nov 2024 15:57:28 +0000 Received: from [192.168.1.150] (dsl-hkibng22-50ddb7-241.dhcp.inet.fi [80.221.183.241]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: hlinnaka) by meesny.iki.fi (Postfix) with ESMTPSA id 4Xhx1W46KZzyT2; Mon, 4 Nov 2024 17:57:19 +0200 (EET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=meesny; t=1730735840; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=iFuZvR94EIPjO4gVBjseDH+IIMYhpTzgaR9tt7Qhptk=; b=WMKN5mwgRmSgEfToLndf9ykX5o9o3Osm1XE835FIB0PmWDAqqnssZVB1efOuF8tS94NLaG LmQU4NM3zE4gdnB/1wKPHnDFdUlkOPnmEoudshPoUkI4NdYUqbtGlpIuXsl/07f49KjMTJ +REav79417r//3EFWBO9v/4izOh34ao= ARC-Seal: i=1; s=meesny; d=iki.fi; t=1730735840; a=rsa-sha256; cv=none; b=ICsxZbRUky4X2H8OtOJeDYEyfW/65AvCwYHnjY7BDokR+eGrRK5soDmll4zo81OmZNuI2Y v6r0ijUMp2taKoXMGG2dg8EBJ/+6VT8/berhDshOLhDHPd40hXT6+ISyFd9et1tcB59SRK j9P8sG36dJHHLObMAl6RemBeisHI72U= ARC-Authentication-Results: i=1; ORIGINATING; auth=pass smtp.auth=hlinnaka smtp.mailfrom=hlinnaka@iki.fi ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=meesny; t=1730735840; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=iFuZvR94EIPjO4gVBjseDH+IIMYhpTzgaR9tt7Qhptk=; b=pmciVGE+3eNFX0/hEI+/TVrpHuwGOdV4EnD78YrWMUDvmwM2EPXWJe0J2ZfEvtycDHDicM dTYCljJNJ1NW+ayWpVfKENAu/hMlrQxEmAUqh7kg+DvmDl8J8+0bZNxvFWMnI/Ih7K7HMe cFJPju/Z590sz2FEqedpS1f4mlYwpcw= Message-ID: <8d60e621-e971-458e-9e20-f5902c8c852a@iki.fi> Date: Mon, 4 Nov 2024 17:57:19 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pgsql: Implement pg_wal_replay_wait() stored procedure To: Robert Haas , Alvaro Herrera Cc: Alexander Korotkov , Michael Paquier , Pavel Borisov , Peter Eisentraut , pgsql-hackers References: <202411041419.qif3lqaisktw@alvherre.pgsql> Content-Language: en-US From: Heikki Linnakangas In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Spam: Yes List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 04/11/2024 17:53, Robert Haas wrote: > On Mon, Nov 4, 2024 at 9:19 AM Alvaro Herrera wrote: >> It's looking to me like there's just too much cruft in the quest to >> avoid having to reach consensus on new syntax. This might be a mistake. >> Is it possible to backtrack on that decision? > > There's also the patch that Heikki posted to wait using a > protocol-level facility. It was Peter E > Maybe that's just a better fit and we don't need either a procedure > or new syntax. I think it would still be good to expose the feature at SQL level too. Makes it easier to test and makes it usable without client library changes, for example. -- Heikki Linnakangas Neon (https://neon.tech)