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 1tybqO-008tbQ-Tz for pgsql-hackers@arkaria.postgresql.org; Sat, 29 Mar 2025 19:27:48 +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 1tybqM-00FgWu-Ng for pgsql-hackers@arkaria.postgresql.org; Sat, 29 Mar 2025 19:27:46 +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 1tybqM-00FgWl-CX for pgsql-hackers@lists.postgresql.org; Sat, 29 Mar 2025 19:27:46 +0000 Received: from mail-lj1-x234.google.com ([2a00:1450:4864:20::234]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tybqC-001qVW-0x for pgsql-hackers@postgresql.org; Sat, 29 Mar 2025 19:27:44 +0000 Received: by mail-lj1-x234.google.com with SMTP id 38308e7fff4ca-30bfb6ab47cso31668281fa.3 for ; Sat, 29 Mar 2025 12:27:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1743276455; x=1743881255; 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=Deqi2oy29kPsl6A5RI3dk/L7OUP1dLL4cj4pNEl577s=; b=npb0hES/TZ9tGZW0AucWhMHdZknKi284LDChBpwqskCfj/V3LrVIXYD/Dt56KrKeiZ ywlF9VGJ74/9AYcT77Jm2FGKmiHHzQxzYT88RwFwGMHwGR99OdQyIptF6nCpuowLUMb/ zdJv2FJk6BvE9FkCZgqcfmrpZLSFYHomRXVQxbLNxE1dKdGaRfxFUEDxQVYLT47cFgca Zanfe5JYHCgJF3n5v2pL0EcwHanUniPtzZI3fNziqRxcpV93uP9cEO+ZP+gVbaa1xihM 9xfcONwl+q/VaMo6W9HaJhcWTr1wCatxh8rX02ht67X+q01ClkYXb8Zj+JNd4iGJlcBh pIQw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743276455; x=1743881255; 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=Deqi2oy29kPsl6A5RI3dk/L7OUP1dLL4cj4pNEl577s=; b=OfvQZERX4tRdxm9FZ57FWx4Pvd4lgAbcy0++c7Js/1zEtLtz0vu89/NtZ9Moo4HeKA DUBU1Ng37pylxzFhA1ZCnBijNBzH1i1odF035rflFuSzTEeZ6HISnmlX8+tQJwJ0XeSu y1RQFPzurw5FSzijEthq+/H2HiFgI1Gwgfkkt3tD0fYSsqQb9w/trwGG2fY7CiW7QGv3 lk2kgwC+mfwkhWdtxXXTzzA9wGiiYepZ69rYTbsWWkT87ol7F7kceDoJNpGX+MUZstzx wDHLvwKfE6hFodJLfcNhWFub0JhPPrbATQbhC3SsAv7QSeQyNkXtrEEAy1CTDVf8W64q 0MOg== X-Forwarded-Encrypted: i=1; AJvYcCX774epFaOqEWHg7Bp09Pb0Z7ZzPGz/k6IvxYc3z0nNZSQuMNRDmaSxt5MvJGw/lh+HfpTXP/AdAM+ISqES@postgresql.org X-Gm-Message-State: AOJu0YxUiGn0QmF7Zg+Ril2ViNijJiRCCftnwZliOb/DD0SgKDroHrYI KnlKwH7cDVxIQt0CkKF+hBk9hNl8F0UASjaLJPi7M3jBNfosDdk06kGpbeB+ZyY3J3LZEVqnSaJ XYqjD8eJzGClD0h8iiNOaoGDikdg= X-Gm-Gg: ASbGncs2TX3caqMpfP86KSJUufhqbMMhnvHVv256hlQMIC7PLEO2BurDoIZTGUZdZWG KjGIzO3lq451JHU3QIdmaxUP3f3q3OGRE3igaesn5jeQhiyuR2rqd7c0P6s3cGE4RMOVn8KnFGY 0yfE0p+2AeKpgfNWo5GVJ29Fs1qRqe X-Google-Smtp-Source: AGHT+IGgA9YvDi9QDQSIgoKM2SRa+cbhvFcgjeYWIDkAR7iUAoe2rjl4PFxZYyIrHKe70ojsujEO7xPA8p1yrtUnHyk= X-Received: by 2002:a2e:a99a:0:b0:30b:f924:357c with SMTP id 38308e7fff4ca-30de024881bmr10949491fa.15.1743276454382; Sat, 29 Mar 2025 12:27:34 -0700 (PDT) MIME-Version: 1.0 References: <442e62f7-ef64-4df1-8453-d682fe9bdaa3@dunslane.net> In-Reply-To: From: Kirill Reshke Date: Sat, 29 Mar 2025 20:27:22 +0100 X-Gm-Features: AQ5f1JoSnMMXJj-aTt9lCTFlvcDxhKAvSJ8WNp8wQbP2594VPy2zRcoBGea8NTg Message-ID: Subject: Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). To: "David G. Johnston" Cc: Andrew Dunstan , jian he , PostgreSQL-development , Tom Lane , Michael Paquier Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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? > > David J. > I do also support what this patch aims to do, how do you like v1? -- Best regards, Kirill Reshke