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 data type | Argument data types | Type
| Security | Volatility | Owner | Language | Source code | Description
------------+------+--------------------------+---------------------+-------
-+----------+------------+-------+----------+-------------+-----------------
---------
pg_catalog | now | timestamp with time zone | | normal
| invoker | stable | pgres | internal | now | current
transaction time
it's the timestamp at the start of the transaction- so the planner should
have a set value for all rows.
Am I missing something else?
Mike