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 1s848y-009PIq-Qs for pgsql-hackers@arkaria.postgresql.org; Fri, 17 May 2024 20:25:34 +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 1s848y-00HaQg-GI for pgsql-hackers@arkaria.postgresql.org; Fri, 17 May 2024 20:25:32 +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 1s848y-00HaQY-6i for pgsql-hackers@lists.postgresql.org; Fri, 17 May 2024 20:25:32 +0000 Received: from mail-yw1-x1130.google.com ([2607:f8b0:4864:20::1130]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s848u-000lkK-OL for pgsql-hackers@postgresql.org; Fri, 17 May 2024 20:25:31 +0000 Received: by mail-yw1-x1130.google.com with SMTP id 00721157ae682-61bec6bab2bso6441617b3.1 for ; Fri, 17 May 2024 13:25:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1715977528; x=1716582328; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=PejUO2bbcXPYTgrgCdplscamL0AqKt7pJZZ1Wuz1VqA=; b=kYAQDAvBzEq0ON9qjPtOjqjDu6c23OWQXi8cWYy+dSOt8snsCKPBkmlE4wIuAoO1bT QaMtbtENF0mAUh9O1tc0BsgLDGc2yU9kdwO8Y9ckIDyahQfr1o+WEAXDdNT6yT7Iz2ji pKEK0oQ97OVC6/k6X+AtlAr+vfqz3/3MO5nV+7jz6wwxXGD1nc+hjt60k1V9JbZdn4pm vkuwg3BfBOACGnHXvLw/vsKaTUqImylEUkD0f4J/hy31UuofRrK9s9CBNCOmRzoMXuEC 24H+BmYZbFy8S5n+jeMZv3Tl/93HPWR5sfCY4r8urde9P6Ue/q0po++xlqMxs8Igbo+m KuNA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1715977528; x=1716582328; h=content-transfer-encoding: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=PejUO2bbcXPYTgrgCdplscamL0AqKt7pJZZ1Wuz1VqA=; b=KcGqmg61q3Y25Az4QvKoYUMBRwwJJ0yhC7mjwSWHzekRcD64d7Q0QYOwNMSyES3IfL Rg1Z5ELNCFjZAUshr0UlF9ILBUZUQYFclxrUA29288HEaLBNyJRXHe1sc//BqSfStEMI 7JzQ244Igwwd9Y3ZqY56Z+lsZ3LlVX/I/jCy7B1StG2tH7YdlNRmh9r7RalVtDhnv0/0 UeHY4fca7BMiP9S+NXQ4QaHPQmlI9pWz8PzqjzuKqn42CN0VR6wfnQHVXSTfqXydaQ2a IfGN284ce+RAGoEWRcv6AmlFTEWiwR1IhzlFzS8Mm6Mn0xxTfW7xubNGFXkYTUqJQE9z 1DQQ== X-Forwarded-Encrypted: i=1; AJvYcCXL2qNsHlgIZJUj8zuG2sSBgq180AyEBnyMSBF3D+/Ir83aDNVDAf0UIXaS3PTWwU3fpaV+cAIAn6zWECQ2E9SkdE9I0kYtV/fQlD8v X-Gm-Message-State: AOJu0YzUYwvQVU3h2Hj6wHxFA4Y/zveeh0hmWqFTidRA2Mxqnw5su9uZ HZZfCXiB4Ab9spVqD3sjHC+Zv4rYOoq+ZP5ScEZhMZCgSUOWM1CnrB2k2gWRIzyteZOfxGJWyvx hh6u8zhufWpSqi21VxM/SDW7uszSoDQ== X-Google-Smtp-Source: AGHT+IFPVBJbFXHkL9+hErRRe6qRxoQ1WVGA9QDiXCDIsxbDqnHJTE3DSAyoHu9wu0StDEe+a18FkGGhyjF2WFX7IGc= X-Received: by 2002:a05:690c:d8f:b0:627:96bd:b1d with SMTP id 00721157ae682-62796bd0e35mr4048127b3.26.1715977527757; Fri, 17 May 2024 13:25:27 -0700 (PDT) MIME-Version: 1.0 References: <20220512034010.4oqa76pasrulkw32@alap3.anarazel.de> <20220512234207.pwwp6q33f72byet2@alap3.anarazel.de> <0892cd00635c8bcd458de6d43d31cf61953da1b2.camel@j-davis.com> <727b0f3b48aec2a4f968bf11c6fa8ca6382b6cca.camel@j-davis.com> <22e756affaad88b77a52d67cb532ed2a544f2e36.camel@j-davis.com> <1e2256b744836aeb485c61954e9d8272f80141a0.camel@j-davis.com> In-Reply-To: <1e2256b744836aeb485c61954e9d8272f80141a0.camel@j-davis.com> From: Robert Haas Date: Fri, 17 May 2024 16:25:15 -0400 Message-ID: Subject: Re: Comments on Custom RMGRs To: Jeff Davis Cc: Danil Anisimow , Andres Freund , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, May 17, 2024 at 4:20=E2=80=AFPM Jeff Davis wrot= e: > Regarding this particular change: the checkpointing hook seems more > like a table AM feature, so I agree with you that we should have a good > idea how a real table AM might use this, rather than only > pg_stat_statements. I would even be OK with a pg_stat_statements example that is fully working and fully explained. I just don't want to have no example at all. The original proposal has been changed twice because of complaints that the hook wasn't quite useful enough, but I think that only proves that v3 is closer to being useful than v1. If v1 is 40% of the way to useful and v3 is 120% of the way to useful, wonderful! But if v1 is 20% of the way to being useful and v3 is 60% of the way to being useful, it's not time to commit anything yet. I don't know which is the case, and I think if someone wants this to be committed, they need to explain clearly why it's the first and not the second. --=20 Robert Haas EDB: http://www.enterprisedb.com