Bruce Momjian <[email protected]> writes:
>> * Simon Riggs ([email protected]) 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
