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 1peJgu-0004iF-C1 for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Mar 2023 17:53:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1peJgt-00079i-3t for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Mar 2023 17:53:03 +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 1peJgs-00079Z-P7 for pgsql-hackers@lists.postgresql.org; Mon, 20 Mar 2023 17:53:02 +0000 Received: from mail-oi1-x22f.google.com ([2607:f8b0:4864:20::22f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1peJgq-0003WC-22 for pgsql-hackers@lists.postgresql.org; Mon, 20 Mar 2023 17:53:02 +0000 Received: by mail-oi1-x22f.google.com with SMTP id r36so9323994oiw.7 for ; Mon, 20 Mar 2023 10:52:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=timescale.com; s=google; t=1679334778; 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=jFKoBQ/nRpyoDWQjv1QuEQIaxF3C3Pt5zFlw/fgiiok=; b=DKlGTv5So2Wz/onVEsyCirWoAaaBUs65XUJMq0Tos5FF4HJYHx9MyZ1xW8PRkhzGmQ MCf/a7flIMEjfTRk5+yvGd/P54fs8dddOoADPq+BD/yGIebkNuMVL8IWEIEFTDwvs36Y 6SZIwTZD+8Nj4KeQLKkBJlTS+lvy50JI0edt62dKMkTSsc2g5tMT+rUzHQW9P3gRbfhN I5/G6UMsQO2plj5obCpgAijQ7Lpm5fpt4aR12bGk9EJJxnnlkQrHOAHF3rvf638GS9Bj Licghidmnzs48mfEqICDjpDMYpE58lVaExEHTI0YJ3FBQFQYXbctMpEe6JFiPAqYhOJg 3qkg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1679334778; 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=jFKoBQ/nRpyoDWQjv1QuEQIaxF3C3Pt5zFlw/fgiiok=; b=ok+g64MmIDijsw2eReARX+HHEPE3D8o68sdpaWJN67/tjQ6iSmXWTXGDOhqTFFqzTm GrYGejijhwW/cKwxip0E2HleOCkSVI+N0mw5LuTI2aXxadQFgSQoEa98rtICTKsf7LYo GNbox0HpUrHlsFyxbYZzRyqetzOLxLCNoKlUBuQa2s1f2tKsBDepChv/owCFGgBt2rkg AJIF0HxpR0ipACtADSOLIYqNJ0AlItDdubX8RkRmZ8+aJriaFFLAy1iscM51eNEgxNq6 09tHlOGUJ9T36D1YfF0JtReTYUdqnQuDGhsaw5wu5+1kshwwZxB/4RsNOMOJvmsyQ64q LSPA== X-Gm-Message-State: AO0yUKUI36mTa+RgyniUgcSkpXFmdhRqWjAf45yocOEU6GB25UiE64Ge juYRCL8We8lNBF4OAIdhGXeJR0a0fXGr5bhde0aDnw== X-Google-Smtp-Source: AK7set/bLIZoD3XIvvEO0VNsA86r9vdIHZbDFzOlTcGLy1RKNtDL+kUwFIoI5CcqAZIFusIpack9p01NUJW7rVKbHME= X-Received: by 2002:a54:4897:0:b0:384:2018:571c with SMTP id r23-20020a544897000000b003842018571cmr258681oic.8.1679334778093; Mon, 20 Mar 2023 10:52:58 -0700 (PDT) MIME-Version: 1.0 References: <20230207202834.c2ptvco7dv57t3hi@awork3.anarazel.de> In-Reply-To: From: Jacob Champion Date: Mon, 20 Mar 2023 10:52:46 -0700 Message-ID: Subject: Re: Data is copied twice when specifying both child and parent table in publication To: Amit Kapila Cc: "wangw.fnst@fujitsu.com" , Andres Freund , vignesh C , Peter Smith , "Takamichi Osumi (Fujitsu)" , "shiy.fnst@fujitsu.com" , "houzj.fnst@fujitsu.com" , Amit Langote , Peter Eisentraut , "pgsql-hackers@lists.postgresql.org" , Dilip Kumar , Greg Nancarrow 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, Mar 17, 2023 at 9:45=E2=80=AFPM Amit Kapila wrote: > > There are a bunch of moving parts and hidden subtleties here, and I fel= l > > into a few traps when I was working on my patch, so it'd be nice to hav= e > > additional coverage. I'm happy to contribute effort in that area if it'= s > > helpful. > > I think it depends on what tests you have in mind. Just the ones I mentioned, to start with. > I suggest you can > propose a patch to cover tests for this are in a separate thread. We > can then evaluate those separately. To confirm -- you want me to start a new thread for tests for this patchset? (Tests written against HEAD would likely be obsoleted by this change.) --Jacob