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

From: Shubham Barai <shubhambaraiss(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Optimization- Check the set of conditionals on a WHERE clause against CHECK constraints.
Date: 2016-02-06 17:56:19
Message-ID: CALxAEPtkM8XRCDHgPoGZvtcgxZAhC4HipD8zPLkc9TcnrP=9Kw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Filip Rembiałkowski 2016-02-06 19:15:51 Re: proposal: make NOTIFY list de-duplication optional
Previous Message Andrew Dunstan 2016-02-06 17:50:59 Re: proposal: make NOTIFY list de-duplication optional