Re: [HACKERS] Optimization- Check the set of conditionals on a WHERE clause against CHECK constraints.

[Tom Lane]

Shubham Barai  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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Optimization- Check the set of conditionals on a WHERE clause against CHECK constraints.

[Shubham Barai]

Hello hackers,

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 ?

Any thoughts will be helpful.
Thanks.