Re: [PERFORM] Partition Constraint Exclusion Limits

2015-10-27 Thread Jim Nasby
On 10/27/15 3:33 PM, Vitalii Tymchyshyn wrote: BTW: May be it could be feasible in future to perform partition exclusion during the execution? This would be very neat feature. True exclusion? probably not. The problem is you can't completely exclude something based on any value that could chan

Re: [PERFORM] Partition Constraint Exclusion Limits

2015-10-27 Thread Vitalii Tymchyshyn
BTW: May be it could be feasible in future to perform partition exclusion during the execution? This would be very neat feature. Regards, Vitalii Tymchyshyn Вт, 27 жовт. 2015 15:03 David G. Johnston пише: > On Tue, Oct 27, 2015 at 2:29 PM, GMail wrote: > >> I have partitioned a large table in

Re: [PERFORM] Partition Constraint Exclusion Limits

2015-10-27 Thread David G. Johnston
On Tue, Oct 27, 2015 at 2:29 PM, GMail wrote: > I have partitioned a large table in my PG database (6.7 billion rows!) by > a date column and in general constraint exclusion works well but only in > relatively simple case when the partition key is specified exactly as > created in the CHECK const

[PERFORM] Partition Constraint Exclusion Limits

2015-10-27 Thread GMail
I have partitioned a large table in my PG database (6.7 billion rows!) by a date column and in general constraint exclusion works well but only in relatively simple case when the partition key is specified exactly as created in the CHECK constraint. I'm curious if there is a way to get it to wo