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 1tycBp-008xYJ-6A for pgsql-hackers@arkaria.postgresql.org; Sat, 29 Mar 2025 19:49:57 +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 1tycBn-00Fxm5-Fb for pgsql-hackers@arkaria.postgresql.org; Sat, 29 Mar 2025 19:49:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tycBn-00Fxlx-4W for pgsql-hackers@lists.postgresql.org; Sat, 29 Mar 2025 19:49:55 +0000 Received: from mail-oa1-x34.google.com ([2001:4860:4864:20::34]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tycBl-001qes-1D for pgsql-hackers@postgresql.org; Sat, 29 Mar 2025 19:49:54 +0000 Received: by mail-oa1-x34.google.com with SMTP id 586e51a60fabf-2c76a1b574cso980763fac.2 for ; Sat, 29 Mar 2025 12:49:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1743277792; x=1743882592; 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=kSOIpZeuiDAScoN5r8tJGm7hwT8RA6fTIUCwBLewy7c=; b=bEKQ+lfYksqP3putKZ0Mh+8+aa7Mk76iHXtvO113uNzzmd0oOu/4HqNeEImZazD/zk hThWoP/qgmOYflZYex5NxtnVsmN9isF/uf5agoR41dZVqlRvsrWP6CUvL5nED8UOB2eI n2VnlIBp4h8UpfsMWppRHxOg6KR/8bKV+gYfExyM/WvF1Ck7bxg5v5ceKm6EAbU8C1t+ mDdbI3Rekoft0K+BJTW4FxXHAPVAP0QhEhLrFiWmkPiXbsFIepMTmKFAnf/vieLTJphY w2HmCHCaLgbfo1MRrDPVEwZip9je8E/BZEiBEKsagqQ69SNI5B7VA4CovoEm7k9b93sL poOQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743277792; x=1743882592; 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=kSOIpZeuiDAScoN5r8tJGm7hwT8RA6fTIUCwBLewy7c=; b=EqumktNlh8D3hjMASDN4A+YF7FICPeP9LC05pbPOb4jg0tgklelmMzRruyLQKuqrEx 2YEyQafXj9quysKWCYjZRAEUisuAwWp/aXvvSGXwsILJ8mZqukGcjo13M7WxvLPSL6nb QDKqWFoSU1A1Ocw/ZvLoBvXgdgzr9mw1y4IrYWc6vcwaXFPHgUGsbKQVBgyMUUBSpeyX AU776GK1/pyLSQajWeHqQrcbzkSqJ6YJ3exwUL3tvQQ46xrXQzAtnwIot0nWy6mE4mA/ 5llAbHNr9xQDO1FM2oBvR6yQFIF08uQQOo7PaeszVLaWOyrqKf1yB4vhrf8vfPEeZcyT yqwQ== X-Forwarded-Encrypted: i=1; AJvYcCUbwEE8ufBvx2D9VHhxQQSJj1RlcMWFYaadNQbFFJwCG1qBNWcjLouK+QfQQ5tTFRq+6WA/qbz3xNbiO5oz@postgresql.org X-Gm-Message-State: AOJu0Yw+YUVK7cZAbYI7dKEVmcC0RKJrcHI//WNZMmkD66g/4Fm0bnBT JVlQPGkz9EgmKFjgZWrFTD4MQSlNtTCHQrResgQQu0TOuQfGu8ORIf/cjqt9kqz3RLFHcgnBQs/ UsTMlZxizdf8mdEMTIWS1MVsDP+Y= X-Gm-Gg: ASbGncuvqqy0CH7kix8mWAp2OHjSdlGvTiGdarkZyJu02B9YrKLsoYg4EiNf7h6pOdW vnLiP2hY0RPzeKLpYvPQkChb3R2y/wF8oG9re8OhqspNNT77nF8Rfp+LWUooGgBxGmFUiYmvZRU fQ+uh3iNahCozxk43tZ2ajVekB X-Google-Smtp-Source: AGHT+IGy1XyCwFWYGcr8Uif9ySFyUhby7iqWjQzlyy45pC1pZaN+7N2VeLZEyho2Jm4qrG5AFMszj6+0p7iDSPYgRAc= X-Received: by 2002:a05:6870:8a09:b0:29e:6f32:6d91 with SMTP id 586e51a60fabf-2cbcf8060c7mr1973999fac.33.1743277792538; Sat, 29 Mar 2025 12:49:52 -0700 (PDT) MIME-Version: 1.0 References: <442e62f7-ef64-4df1-8453-d682fe9bdaa3@dunslane.net> In-Reply-To: From: "David G. Johnston" Date: Sat, 29 Mar 2025 12:49:16 -0700 X-Gm-Features: AQ5f1JrTlaS_0kw1ceKX1Fq3rElC74jxU0EudDrNranIKjg0yXqnDdSp2EtQCYc Message-ID: Subject: Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). To: Kirill Reshke Cc: Andrew Dunstan , jian he , PostgreSQL-development , Tom Lane , Michael Paquier Content-Type: multipart/alternative; boundary="00000000000091b7fd0631807de4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000091b7fd0631807de4 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sat, Mar 29, 2025 at 12:27=E2=80=AFPM Kirill Reshke wrote: > On Sat, 29 Mar 2025 at 19:59, David G. Johnston > wrote: > > Regardless, I do support this patch and probably any similar ones > proposed in the future. Do you have an opinion on that? > > > > I do also support what this patch aims to do, how do you like v1? > > Seems reasonable, but I don't have enough experience with the codebase in that area to submit a code review or be aware of any unexpected side-effects or deficiencies. David J. --00000000000091b7fd0631807de4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sat, Mar 29, 2025 at 12:27=E2=80=AFPM Kirill Reshke <= ;reshkekirill@gmail.com> w= rote:
On Sat, 29 Mar 2025 at 19:5= 9, David G. Johnston
<david.g= .johnston@gmail.com> wrote:
> Regardless, I do support this patch and probably any similar ones prop= osed in the future.=C2=A0 Do you have an opinion on that?
>

I do also support what this patch aims to do, how do you like v1?


Seems reasonable, but I don't have enough = experience with the codebase in that area to submit=C2=A0a code review or b= e aware of any unexpected side-effects or deficiencies.

<= div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif= ">David J.

--00000000000091b7fd0631807de4--