Postgres Pro
Downloads
Home   >   mailing lists

Optimization- Check the set of conditionals on a WHERE clause against CHECK constraints. - Mailing list pgsql-hackers

From Shubham Barai
Subject Optimization- Check the set of conditionals on a WHERE clause against CHECK constraints.
Date
Msg-id CALxAEPtkM8XRCDHgPoGZvtcgxZAhC4HipD8zPLkc9TcnrP=9Kw@mail.gmail.com
Whole thread Raw
Responses Re: Optimization- Check the set of conditionals on a WHERE clause against CHECK constraints.
List pgsql-hackers
Tree view
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.


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: proposal: make NOTIFY list de-duplication optional
Next
From: Filip Rembiałkowski
Date:
Subject: Re: proposal: make NOTIFY list de-duplication optional