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 1peVNo-0006wI-Tb for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Mar 2023 06:22:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1peVNn-0000cY-NR for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Mar 2023 06:22:07 +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 1peVNn-0000cP-Bh for pgsql-hackers@lists.postgresql.org; Tue, 21 Mar 2023 06:22:07 +0000 Received: from mail-oa1-x2c.google.com ([2001:4860:4864:20::2c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1peVNk-0002Uy-Ud for pgsql-hackers@lists.postgresql.org; Tue, 21 Mar 2023 06:22:07 +0000 Received: by mail-oa1-x2c.google.com with SMTP id 586e51a60fabf-17aceccdcf6so15297247fac.9 for ; Mon, 20 Mar 2023 23:22:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1679379722; 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=1q9UbOmgWONZr9J+kPEW9oBCVPrlL/EWTBEc8Ce1XJc=; b=BqVXCM2e76rKIcBkpHcA39cBbDCSB4QGF2LOurEblMBtAOyJs6YCrxl1iaFlvu3Jym Se1NrEAnGU7jp35vb+p/flTNISjhn0EX10rnDNKYX4o5gCyKXCJg+IjdTOXl5ub5GCih HS3rQHSj4yAnMd8wz0yQbjnT0HOZgRoCLRioBHrs6QLy8ui9Nzire1xDeaoeFa+eOFaE wFZJJnnpgJMMMbownqkGerKS4yxMYNlgu9pg20qfl36BOg28XnXu2FlpRs7AliQ2j64a HZKtf/I7s/uoLt6cJco85VIwfIuZfjvZMsLMrkjrQzTqZRBy8fSNyVyq24Kr8J7tLX4v ZYug== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1679379722; 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=1q9UbOmgWONZr9J+kPEW9oBCVPrlL/EWTBEc8Ce1XJc=; b=TkJq19BAN3DXpIfAxG0Xo1hP432yjN7DB/SMnwO+QW1Qy/QZaD8wqebVI5Vu/9OMhv UFfHQOqZGe003IRRA9sfBmWUyCOCEGxBpuuWeo21JvKp0xXta9nZZrlYB3tFNd4wDZUc 4WkxlmQCfkzzjYQlDx0wbkEdR+wKrIp3G0CaFbE/UlZdd+SZ1CMxgbjec4Az3lJP4YW2 Y9Q6wFgwPnZIVXjpiY+oSIVZoZk1lrm6XM4bdbniwniAVfrczm3Av0+SWUynlo+RIp8v oEFPDRcg1oqi70Su5g7M6m7AFl9b3EAmbdaCM7615Bqbn+0RJ7XD7KsjbN8e6Zt0/01r mJRw== X-Gm-Message-State: AO0yUKUDT4rVnmD3JZ/qvDSaLM4kMjnKcM7roDD3fWo8BsJg4fEv5xWx lAylLn8NBZHPg/voEe/mX5NfQihpJId7Vh6OqYU= X-Google-Smtp-Source: AK7set+3PEtfvylEU0PmyaYXZWCSQkljzgwz/rr2uVf46NgCRmtKxGXiSR/vn+7/ArdGvGMNO9/Lk7pKFe9eJE4gv0c= X-Received: by 2002:a05:6871:4911:b0:17b:5f31:7af1 with SMTP id tw17-20020a056871491100b0017b5f317af1mr289905oab.2.1679379722564; Mon, 20 Mar 2023 23:22:02 -0700 (PDT) MIME-Version: 1.0 References: <20230207202834.c2ptvco7dv57t3hi@awork3.anarazel.de> In-Reply-To: From: Amit Kapila Date: Tue, 21 Mar 2023 11:51:51 +0530 Message-ID: Subject: Re: Data is copied twice when specifying both child and parent table in publication To: Jacob Champion 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 Mon, Mar 20, 2023 at 11:22=E2=80=AFPM Jacob Champion wrote: > > 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 f= ell > > > into a few traps when I was working on my patch, so it'd be nice to h= ave > > > additional coverage. I'm happy to contribute effort in that area if i= t'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.) > If the tests you have in mind are only related to this patch set then feel free to propose them here if you feel the current ones are not sufficient. I just want to be cautious that we shouldn't spend too much time adding additional tests which are related to the base functionality as we have left with less time for the last CF and I would like to push the change for HEAD before that. --=20 With Regards, Amit Kapila.