Horton
Menu

Re: speedup COPY TO for partitioned table.

Nathan Bossart <nathandbossart@gmail.com>

View thread
From: Nathan Bossart <nathandbossart@gmail.com>
To: Melih Mutlu <m.melihmutlu@gmail.com>
Cc: jian he <jian.universality@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-01-27T20:30:17Z
Lists: pgsql-hackers 
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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Support COPY TO for partitioned tables.

  2. Re-implement the ereport() macro using __VA_ARGS__.