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 1rfhhr-001hb7-5u for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Feb 2024 14:48:19 +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 1rfhhp-004b9J-Fh for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Feb 2024 14:48:17 +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 1rfhhp-004b9B-3K for pgsql-hackers@lists.postgresql.org; Thu, 29 Feb 2024 14:48:17 +0000 Received: from mail-oo1-xc29.google.com ([2607:f8b0:4864:20::c29]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rfhhi-0026NL-4x for pgsql-hackers@postgresql.org; Thu, 29 Feb 2024 14:48:16 +0000 Received: by mail-oo1-xc29.google.com with SMTP id 006d021491bc7-5a02e5c5d2dso421021eaf.1 for ; Thu, 29 Feb 2024 06:48:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1709218088; x=1709822888; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=2dbTzvBiP3TXQxZj0AIW5KvsrYRw2AdROWfZUdYwd24=; b=nIXzxZjWFWbc7AUQLbKEwHlbL6i6G2GeM4eIjSuQLjZB+scl4jD/7Tgggm84rl513H egjAAy1yYQ9im6MQVlq6WoUAmmMwq0W6WRUNFdE0pS+1wQDL4kZX5W27aMaJhgQMfi9b LoJkRAtPkVFu4Wb/0qfAkMp7BsN+FlWpvlO0xjdLx5+pbW14vKnDGIko6ntvk8VSILHR 5oY/zS/YzGY7yRMAR8U/z6ZQdxd8cpjqMXgRjepk1kRvWe6toII95OfOPpSma1XofylZ j833o46pXXSd6mFT0mXAU3/5BzqJfSvz037qEJHGnoi7ExBRQfS7LyQfbZ8ET5I246FM igQw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1709218088; x=1709822888; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=2dbTzvBiP3TXQxZj0AIW5KvsrYRw2AdROWfZUdYwd24=; b=ex+wSpGEtoxlCeJbH/r55IKGM2wr5L3gCJCEtL5ais0Ql6zbm9womPcsQVJ/KYwQ0R UH8kfJfVQUfbCb7SyAfPxhGUZ7Y6KCjOCo7WHP4TIUvsn0bKLUtueewlA8ngt3gzlJxY KhAuFeUXvkF9YCa0Q09qs8HEWcvXr3yj4Frasfl72/dU0x8eP0Cn+Mryu95CCX7NyYtH yI0GHvU1acSoC7kn6i9ctutv3LB4g2UGDO5+3271vgEKnp/0C51Oe/TBP4H6eR4f9SwK 5fFLDuxHmIdwrgIUttwz/RBaQUPfgzG+dCDOFcfMNRj7EYD8+KvRt1xtuGI1jBGGIG3z vUVg== X-Forwarded-Encrypted: i=1; AJvYcCVz5RUiGs7qHl35/MrJyqsPlS31y97djWsWdtPrY0ZdsZfk154VS79Bqi2DGv9UYvfGtIEKLwhj82AMzkgh7oID9dx7Z+TdCK8sCf7U X-Gm-Message-State: AOJu0YynwAEbkQxr2/C0qQbapaB12ANYp0Q0Dgf+Urdq1NtvNowfkNP0 c4Rtxg3avm0Fl+5I8402mA0OOzw31OugO3qeEWhuaeR/r85si3cSMR/PWU/JBU2yfitez2S4EE8 MPbgdcd6U2zLV/WTtKFwIOqGLgQ8I6qeRb7s= X-Google-Smtp-Source: AGHT+IHUVuX+x85C8uUq/BzpWoZUVI7uO9tTIhl4zwTQAOY4ZrH3B6m6IMiFWcLw5pworIrLKqstxU4SWBcXLpYIJDc= X-Received: by 2002:a4a:dfb3:0:b0:5a0:e788:15c9 with SMTP id k19-20020a4adfb3000000b005a0e78815c9mr888234ook.0.1709218088678; Thu, 29 Feb 2024 06:48:08 -0800 (PST) MIME-Version: 1.0 References: <20220512034010.4oqa76pasrulkw32@alap3.anarazel.de> <20220512234207.pwwp6q33f72byet2@alap3.anarazel.de> <0892cd00635c8bcd458de6d43d31cf61953da1b2.camel@j-davis.com> In-Reply-To: <0892cd00635c8bcd458de6d43d31cf61953da1b2.camel@j-davis.com> From: Danil Anisimow Date: Thu, 29 Feb 2024 21:47:57 +0700 Message-ID: Subject: Re: Comments on Custom RMGRs To: Jeff Davis Cc: Simon Riggs , Andres Freund , PostgreSQL Hackers Content-Type: multipart/alternative; boundary="00000000000004f9840612865959" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000004f9840612865959 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Feb 27, 2024 at 2:56=E2=80=AFAM Jeff Davis wrot= e: > Let's pick this discussion back up, then. Where should the hook go? > Does it need to be broken into phases like resource owners? What > guidance can we provide to extension authors to use it correctly? > > Simon's right that these things don't need to be 100% answered for > every hook we add; but I agree with Andres and Robert that this could > benefit from some more discussion about the details. > > The proposal calls the hook right after CheckPointPredicate() and > before CheckPointBuffers(). Is that the right place for the use case > you have in mind with pg_stat_statements? Hello! Answering your questions might take some time as I want to write a sample patch for pg_stat_statements and make some tests. What do you think about putting the patch to commitfest as it closing in a few hours? -- Regards, Daniil Anisimov Postgres Professional: http://postgrespro.com --00000000000004f9840612865959 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Feb 27, 2024 at 2:56=E2=80=AFAM Jeff Davis <pgsql@j-davis.com> wrote:
> = Let's pick this discussion back up, then. Where should the hook go?
= > Does it need to be broken into phases like resource owners? What
&g= t; guidance can we provide to extension authors to use it correctly?
>= ;
> Simon's right that these things don't need to be 100% ans= wered for
> every hook we add; but I agree with Andres and Robert tha= t this could
> benefit from some more discussion about the details.>
> The proposal calls the hook right after CheckPointPredicate(= ) and
> before CheckPointBuffers(). Is that the right place for the u= se case
> you have in mind with pg_stat_statements?

Hello!
=
Answering your questions might take some time as I want to write a samp= le patch for pg_stat_statements and make some tests.
What do you think a= bout putting the patch to commitfest as it closing in a few hours?

-= -
Regards,
Daniil Anisimov
Postgres Professional: http://postgrespro.com
--00000000000004f9840612865959--