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
- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
