Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nopNU-0008Rv-Fo for pgsql-hackers@arkaria.postgresql.org; Wed, 11 May 2022 16:39:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nopNT-0003fx-Bo for pgsql-hackers@arkaria.postgresql.org; Wed, 11 May 2022 16:39:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nopNT-0003fn-01 for pgsql-hackers@lists.postgresql.org; Wed, 11 May 2022 16:39:55 +0000 Received: from mail-pg1-x530.google.com ([2607:f8b0:4864:20::530]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nopNQ-0005w9-Ol for pgsql-hackers@postgresql.org; Wed, 11 May 2022 16:39:54 +0000 Received: by mail-pg1-x530.google.com with SMTP id 137so2265011pgb.5 for ; Wed, 11 May 2022 09:39:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20210112.gappssmtp.com; s=20210112; h=message-id:subject:from:to:date:in-reply-to:references:mime-version :content-transfer-encoding; bh=nK3f54f6ygz5aUEJ74LDREhp7iQ8hStbiIANk6JQies=; b=XKThsshksPfsDjILTOHjopbt2Osd4MGBkwpFqcKGR9zRrfzI7F484Q4v/Tie18QJMb 1jpBXoGSgMV4PupshoZyjAYhLu9/ZmeS0dCtfsj+q46L/pjO1l1B0EmDXPn1P3enezGA cDOiRnlDKXhzHwSKjn2z12tK/B9PQ4D86hD5SA3Cpp9SCwvIr5BvIJf2fh7173qS7UtS tdBFS4lJHXLmHKWivQyPSTiVfEUKN6HVBPZW80byRB4j4pZta5ipHwrBSOZK7elpW248 OwlcYYkOqNGQzc414RZFcs2aGakDa+eIkVgKlOIFF/aZxaJABqkm70sekcDnuNDg0V2n e5Sw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:mime-version:content-transfer-encoding; bh=nK3f54f6ygz5aUEJ74LDREhp7iQ8hStbiIANk6JQies=; b=7UwC3RWwpvQ2mzH2yaeheru+uWdfXkgT6ob0diAA4ubti9pXkA9mp9abdJbc/riZv0 x7BH25QEF4NC0VsvEuf6J7MO6WLD92kG8w5RbAxyyBNTygk35rXsjY3RYY/0BuFit1Do cQqvNZ6Q4EUj0Tc6/Kup8seFYfLa8JDZl+1PqtUR5pzt4nEAyACyVvVS6Y6e+pTSgbnu Cw2u8QYkRq9x5QUcs92hasC8Gw7zaWIafbw9uPLRFaN4/t1BqAXb7R1+zFzTf2KcLkor zEAcKxiVwDgYq6XcPKwLNnQWUZsFt+FjrF5gjHDGD3wqXchU+0viwPKoRSj7Lx84DFoJ uDCA== X-Gm-Message-State: AOAM532nPGrOG5n7XxtQcI7zSPAu+/om8LR1fLMwJIkX7a3o0w/CgfiX DNKZt+I1Re7AbYj0unOON2m99w== X-Google-Smtp-Source: ABdhPJwTl/LqI2ikFuERd6SXSeFeUfOqwPVpNtIXKivZW/KWTfktR6i8ZC7JqvruaTDEyyvy08FvIg== X-Received: by 2002:a05:6a00:18a9:b0:50d:d41b:7240 with SMTP id x41-20020a056a0018a900b0050dd41b7240mr25523193pfh.66.1652287190420; Wed, 11 May 2022 09:39:50 -0700 (PDT) Received: from jdavis.lan (c-73-231-146-4.hsd1.ca.comcast.net. [73.231.146.4]) by smtp.gmail.com with ESMTPSA id v13-20020a1709028d8d00b0015e8d4eb294sm2142899plo.222.2022.05.11.09.39.49 (version=TLS1_2 cipher=ECDHE-ECDSA-CHACHA20-POLY1305 bits=256/256); Wed, 11 May 2022 09:39:49 -0700 (PDT) Message-ID: Subject: Re: Comments on Custom RMGRs From: Jeff Davis To: Simon Riggs , PostgreSQL Hackers Date: Wed, 11 May 2022 09:39:48 -0700 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.28.5-0ubuntu0.18.04.2 Mime-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2022-05-11 at 15:24 +0100, Simon Riggs wrote: > [PATCH: rmgr_001.v1.patch] > > [PATCH: rmgr_002.v1.patch] Thank you. Both of these look like good ideas, and I will commit them in a few days assuming that nobody else sees a problem. > It occurs to me that any use of WAL presumes that Checkpoints exist > and do something useful. However, the custom rmgr interface doesn't > allow you to specify any actions on checkpoint, so ends up being > limited in scope. So I think we also need an rm_checkpoint() call - > which would be a no-op for existing rmgrs. > [PATCH: rmgr_003.v1.patch] I also like this idea, but can you describe the intended use case? I looked through CheckPointGuts() and I'm not sure what else a custom AM might want to do. Maybe sync special files in a way that's not handled with RegisterSyncRequest()? Regards, Jeff Davis