Re: [GENERAL] Problem with constraint exclusion on partitions

2014-12-19 Thread Mike Pultz
Hey David, > What version are you using? Sorry, I'm on 9.3.4. >Now() is a volatile function so the planner cannot omit partitions. > >Replace that with a constant and now it can. I'm not sure what you mean- now() is a stable function: cloud_test2=# \df+ now() Schema | Name | Result d

[GENERAL] Problem with constraint exclusion on partitions

2014-12-19 Thread Mike Pultz
Hello, I'm having an issue getting the query planner to skip child tables based on my check constraints. I have constraint_exclusion = partition in my config file, and I think I have everything set up correctly. The parent table shows the child tables: cloud_test2=# \d+ engine_