Martin,
> which if you dont want to scan ALL partitions must be set to 'on'
> constraint_exclusion = on
It is 'ON'. The problem is that it does not work well for 'UPDATE foo
... FROM bar' queries, when partitioned table 'foo' is joined with
another table.
Martin Gainty wrote:
> Alex-
>
> http://www.postgresql.org/docs/8.2/static/runtime-config-query.html#GUC-CONS
> TRAINT-EXCLUSION
> postgresql.conf contains a constraint_exclusion parameter called
> constraint_exclusion (boolean)
> which if you dont want to scan ALL partitions must be set to 'on'
> constraint_exclusion = on
>
> HTH
> Martin