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 CALdSSPhCu-AbGyQDDSLJyvAj8Zy=uHA6cCr4pS9Jv+6cvD_cRQ@mail.gmail.com
Whole thread Raw
In response to Re: speedup COPY TO for partitioned table.  (jian he <jian.universality@gmail.com>)
Responses Re: speedup COPY TO for partitioned table.
List pgsql-hackers
On Thu, 10 Apr 2025 at 07:45, jian he <jian.universality@gmail.com> wrote:
>
> hi.
>
> rebase and simplify regress tests.

HI!
You used CREATE TABLE PARTITION OF syntax for the second level of
partitioning scheme, but not for the first level. Is there any reason?

Also about column names. how about

+CREATE TABLE pp (year int, day int) PARTITION BY RANGE (year);
+CREATE TABLE pp_1 (year int, day int) PARTITION BY RANGE (day);
+CREATE TABLE pp_2 (year int, day int) PARTITION BY RANGE (day);

??




-- 
Best regards,
Kirill Reshke



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Improve a few appendStringInfo calls new to v18
Next
From: Tender Wang
Date:
Subject: Re: Consistently use macro HeapTupleIsValid to check the validity of tuples in tablecmds.c