Shubham Barai <shubhambaraiss(at)gmail(dot)com> writes:
> I was searching for project ideas and found this
> 1.Optimization- Check the set of conditionals on a WHERE clause against
> CHECK constraints on the table being queried and remove any conditionals
> which *must* be true due to the CHECK constraints.
> Is it expensive for simple queries?
> will it optimize general queries ?
TBH, it sounds like it would almost always be a waste of planning cycles.
I doubt that typical applications would issue many queries in which such
an optimization would apply.
regards, tom lane