| From: | Kirill Reshke <reshkekirill(at)gmail(dot)com> |
|---|---|
| To: | jian he <jian(dot)universality(at)gmail(dot)com> |
| Cc: | vignesh C <vignesh21(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Melih Mutlu <m(dot)melihmutlu(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: speedup COPY TO for partitioned table. |
| Date: | 2025-04-10 08:25:00 |
| Message-ID: | CALdSSPhCu-AbGyQDDSLJyvAj8Zy=uHA6cCr4pS9Jv+6cvD_cRQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 10 Apr 2025 at 07:45, jian he <jian(dot)universality(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tender Wang | 2025-04-10 08:44:24 | Re: Consistently use macro HeapTupleIsValid to check the validity of tuples in tablecmds.c |
| Previous Message | Heikki Linnakangas | 2025-04-10 08:24:36 | Re: Improve a few appendStringInfo calls new to v18 |