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 1tcVkW-000cOx-2g for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Jan 2025 20:30:24 +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 1tcVkV-00ESL5-1T for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Jan 2025 20:30:23 +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 1tcVkU-00ESKx-OV for pgsql-hackers@lists.postgresql.org; Mon, 27 Jan 2025 20:30:22 +0000 Received: from mail-il1-x131.google.com ([2607:f8b0:4864:20::131]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tcVkS-001oyL-1d for pgsql-hackers@lists.postgresql.org; Mon, 27 Jan 2025 20:30:21 +0000 Received: by mail-il1-x131.google.com with SMTP id e9e14a558f8ab-3a813899384so12068255ab.1 for ; Mon, 27 Jan 2025 12:30:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1738009820; x=1738614620; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=jqDHXh6oQ0DbSOb3h6LpOnQREDNJUe96KWUjaBrZ4U0=; b=Ad5G1dQJHYT1XmKIQ6UqI7yZCzGDK9Fo+viI5quv4M3MDoaBm6ZU3fCSPGnmkvjLJ/ mRYCGtztZu2xvN8bjTxvDyVfiTjW0dgKt2I/ziFmu8RAyKmBuDvmOSmheqOEGsLCzbeX +5YLUAisCzKb+Z2iUec1RaGQvi9lIVQubYE5jwDbOfe3u92VsyDZPFNPNTpsj05hW6Tr o+VD1XvZ6rniMUaIcV4NFcOVRLAbR8rbLwls+SIUvnjZPQdm+wz+ZZPGWC3ib873Zrmj c9QCt0yawx2yrfxoHCkphZvQFNX1RlSlbIunAQk6HcbgMVXbz1kbYSt4L5p8Q3o1JI9T KOZw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738009820; x=1738614620; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=jqDHXh6oQ0DbSOb3h6LpOnQREDNJUe96KWUjaBrZ4U0=; b=f7YJhuyMfsNhizMzD95+Z0sguWbScYRgxJkDmqazp5CPVNVZxysrBPKJ5Wf4G2dWzb Ps2rUUtZG/ecURpdBjEN3n1IRjYVCCkSW+I+fNS8s6hKXj9TYLoblXYV/qB8YrlMcXF1 UzUPsf3KyS10E48Y5ziRP9ub2G1Xw8NmxJZr8MJiooiXaZ775qk5kT8MVny87rvx2RMY N768bqdxexzGQBBoE+tcDkepZLxShfXb5fQAxRHz9wFsdacViHT/FL5pYURJy/HQeUCW 7g9qC448Q5V6q4N3ozynp/ZaZMOXZ4qK07VMK9uZ5I8z7OyUZLN2u/gzfaHwG5MxIXie Axwg== X-Forwarded-Encrypted: i=1; AJvYcCWhI67qsD4uXmYcfIVN6GtopapcNS9w8b4uicJlvM6bu1LVPsZfUCXxZn1YNmm0DVjK4V/s4+NAD782+160@lists.postgresql.org X-Gm-Message-State: AOJu0YzZoaEorQCqeJGP/TNyoHcgDZqetuVga9mxrawT2XMkwRAJ2dw7 i0ixRSUCh2gp+KZ3FKVZBkFATz1MZxAgOSm4FwJXdPfFvWv/cK4x X-Gm-Gg: ASbGncsVn15OIN9LPU2My55shfphMn8yfpKu4Au17naUogPNMO94pM3Bl5ojsJZI6SZ BroAeRPmBJGieQiAj/zuU6an0r00OQY+iLkKHae8A81lPsEVPn+O7XpShSjIsvRX2BNIAULZF5n /XvhJPiGWlzsAZFKMicu6JIiND2t3yFYwFB7Zh7PHVzQoyxbYpjZPWJoNN/CljsWkqe1/dlvqxw StdIlZb5Db+Hqfqw2LgepqA82U6txS6Anz8rqJDYuhXlgaAnhy5oH8benX+1XrBYudGtx1yEx5Q vMjWIvNpL4PT69MjyZ8Nfp24Odl3YId5B7zHkZjmLpyShZchsDQ1J2jIU0TvAiJqbvyUdmsVhD7 UE9mgdA== X-Google-Smtp-Source: AGHT+IEwyDbTlFjwGpCf9HllR1U4wsPcfND5dhBndAlkWwNEvURbWRDQOaMly5LUrbmGWuYqZDeDhQ== X-Received: by 2002:a92:c263:0:b0:3cf:c8bf:3b6e with SMTP id e9e14a558f8ab-3cfc8bf3c72mr124680895ab.3.1738009820033; Mon, 27 Jan 2025 12:30:20 -0800 (PST) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-3cfc740f78csm27947055ab.4.2025.01.27.12.30.18 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 27 Jan 2025 12:30:19 -0800 (PST) Date: Mon, 27 Jan 2025 14:30:17 -0600 From: Nathan Bossart To: Melih Mutlu Cc: jian he , PostgreSQL Hackers Subject: Re: speedup COPY TO for partitioned table. Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Jan 22, 2025 at 01:54:32AM +0300, Melih Mutlu wrote: > I confirm that the patch introduces some improvement in simple cases like > the one you shared. I looked around a bit to understand whether there is an > obvious reason why copying from a partitioned table is not allowed, but > couldn't find one. It seems ok to me. From the original discussion [0], it seems like it was considered a nonessential part of an otherwise massive patch set. Perhaps it's time to revisit it. [0] https://postgr.es/m/CAA4eK1LqTqZkPSoonF5_cOz94OUZG9j0PNfLdhi_nPtW82fFVA%40mail.gmail.com -- nathan