Is your Postgres SELECT DISTINCT Does Not Scale

This is so true. Every senior engineer I've worked with knew what needs to be a part of Postgres itself so it builds better query plans automatically.