[GSoC] Optimization tasks

Hello,

My name is Camelia, I carry out Doctoral/PhD research in the field of
database query processing and I'd like to contribute with PostgreSQL
optimization tasks during this year's GSoC:

- Optimization- add to the join removal code the ability to remove joins
to tables when the join is on a foreign key column (where all entries must
exist in the parent anyway)
- 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

and others that may appear interesting along my review of the source code.

I'm very excited about this opportunity and I hope that the results will be
as good!

Will the aforementioned subjects be open for work or do other committers
have them under work already?
Do you have a specific template for the project proposal?

Thank you very much!

Best regards,
Camelia