Cool details. Makes sense, since a database has to have index creation anyway, and if you're avoiding merge joins for code complexity reasons, why not use it to optimize.

An interesting project to manage indexes on postgres that seems tangentially related:

https://github.com/ankane/dexter