Re: speedup COPY TO for partitioned table.

Поиск
Список
Период
Сортировка
От Kirill Reshke
Тема Re: speedup COPY TO for partitioned table.
Дата
Msg-id CALdSSPhCu-AbGyQDDSLJyvAj8Zy=uHA6cCr4pS9Jv+6cvD_cRQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: speedup COPY TO for partitioned table.  (jian he <jian.universality@gmail.com>)
Ответы Re: speedup COPY TO for partitioned table.
Список 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 по дате отправления: