Bruce Momjian <br...@momjian.us> writes:
>> * Simon Riggs (si...@2ndquadrant.com) wrote:
>>> I don't really understand this. Who can set up an inherited table
>>> structure but can't remember to turn on constraint_exclusion?
> This new change also adds the constraint exclusion overhead only for
> inhertance (by default) so it should slightly improve query peformance.
Right, I think that's the real winning argument for having this: it
gets the benefit of c_e for partitioned tables without imposing overhead
for non-partitioned tables. See Josh B's remarks upthread about
actually going to the trouble of turning c_e off and on on-the-fly to
try to approximate that result.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
