Re: [GENERAL] Converting inherited partitions into declarative ones

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Re: [GENERAL] Converting inherited partitions into declarative ones
Дата
Msg-id CAGnEbohxfYVmdaiGe=6-NQZ7LsOyuvnv4Ep=4+TK3wKjA1v-5Q@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Converting inherited partitions into declarative ones  (Victor Yegorov <vyegorov@gmail.com>)
Список pgsql-general
Дерево обсуждения
2017-09-29 20:32 GMT+03:00 Victor Yegorov <vyegorov@gmail.com>:
Is it possible to avoid Full Scan here? I have TBs worth of data in partitions,
so it'll takes ages to switch to the declarative partitioning the way things stand now.

OK, looking at the source code helped — I need to change `created_at` column to be `NOT NULL`.
After this change things are working as expected.

I wonder if it's possible to adjust documentation here:

This does not work, however, if any of the partition keys is an expression and the partition does not accept NULL values
or partitioning column is missing NOT NULL constraint.

?


--
Victor Yegorov

В списке pgsql-general по дате отправления:

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: [GENERAL] Converting inherited partitions into declarative ones
Следующее
От: Andy Colson
Дата:
Сообщение: Re: [GENERAL] PG 10 and perl