Re: [PERFORM] Partitioned table - scans through every partitions

2017-08-25 Thread Aniko Belim
Thank you, Justin! Aniko On 8/25/17, 10:44 AM, "Justin Pryzby" wrote: >On Fri, Aug 25, 2017 at 03:36:29PM +, Aniko Belim wrote: >> Hi, >> >> We have an issue with one of our partitioned tables. It has a column with >> timestamp without time

[PERFORM] Partitioned table - scans through every partitions

2017-08-25 Thread Aniko Belim
Hi, We have an issue with one of our partitioned tables. It has a column with timestamp without time zone type, and we had to partition it daily. To do that, we created the following constraints like this example: CHECK (to_char(impression_time, 'MMDD'::text) = '20170202'::text) The proble