Re: speedup COPY TO for partitioned table. - Mailing list pgsql-hackers

From Kirill Reshke
Subject Re: speedup COPY TO for partitioned table.
Date
Msg-id CALdSSPg_LS7gAZF9Mf0vHw3-XBjw+YyA2PHUxc_ZaNicogyg2w@mail.gmail.com
Whole thread Raw
In response to Re: speedup COPY TO for partitioned table.  (Kirill Reshke <reshkekirill@gmail.com>)
Responses Re: speedup COPY TO for partitioned table.
List pgsql-hackers
Sorry, wrong thread

Best regards,
Kirill Reshke

On Mon, 7 Apr 2025, 19:54 Kirill Reshke, <reshkekirill@gmail.com> wrote:

On Fri, 4 Apr 2025, 15:17 Kirill Reshke, <reshkekirill@gmail.com> wrote:
Hi!

First of all, a commit message does not need to contain SQL examples
of what it does. We should provide human-readable explanations and
that's it.

Next, about changes to src/test/regress/sql/copy2.sql. I find the sql
you used to test really unintuitive. How about CREATE TABLE ...
PARTITION OF syntax? It is also one command instead of two (create +
alter). It is also hard to say what partition structure is, because
column names on different partition levels are the same, just order is
switched. Let's change it to something more intuitive too?



--
Best regards,
Kirill Reshke

Maybe we can tab-complete here if prefix matches pg_% ? Does that makes good use case?

pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: [PoC] Reducing planning time when tables have many partitions
Next
From: Kirill Reshke
Date:
Subject: Re: psql suggestion "select " offers nothing, can we get functions like "\df "