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