Re: [GENERAL] Converting inherited partitions into declarative ones

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

Re: [GENERAL] Converting inherited partitions into declarative ones

2017-09-29 Thread Melvin Davidson
On Fri, Sep 29, 2017 at 1:32 PM, Victor Yegorov wrote: > Greetings. > > I am looking into new partitioning of 10rc1 on a copy of a production > system. > And I'm having tough times with the full scan. > > Per documentation: > > It is possible to avoid this scan by adding a

[GENERAL] Converting inherited partitions into declarative ones

2017-09-29 Thread Victor Yegorov
Greetings. I am looking into new partitioning of 10rc1 on a copy of a production system. And I'm having tough times with the full scan. Per documentation: > It is possible to avoid this scan by adding a valid CHECK constraint to the table > that would allow only the rows satisfying the desired