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

Поиск
Список
Период
Сортировка
От Shubham Barai
Тема Optimization- Check the set of conditionals on a WHERE clause against CHECK constraints.
Дата
Msg-id CALxAEPtkM8XRCDHgPoGZvtcgxZAhC4HipD8zPLkc9TcnrP=9Kw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Optimization- Check the set of conditionals on a WHERE clause against CHECK constraints.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: proposal: make NOTIFY list de-duplication optional
Следующее
От: Filip Rembiałkowski
Дата:
Сообщение: Re: proposal: make NOTIFY list de-duplication optional