Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Converting inherited partitions into declarative ones - Mailing list pgsql-general

From Victor Yegorov
Subject Re: [GENERAL] Converting inherited partitions into declarative ones
Date
Msg-id CAGnEbohxfYVmdaiGe=6-NQZ7LsOyuvnv4Ep=4+TK3wKjA1v-5Q@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Converting inherited partitions into declarative ones  (Victor Yegorov <vyegorov@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] Converting inherited partitions into declarative ones
Next
From: Andy Colson
Date:
Subject: Re: [GENERAL] PG 10 and perl