Search Postgresql Archives

Re: Converting inherited partitions into declarative ones

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2017-09-29 20:32 GMT+03:00 Victor Yegorov <vyegorov@xxxxxxxxx>:
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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux