PostgreSQL

Do you like databases? Do you like Postgres? Please join /pg 

If you reply with an interesting tidbit re: pg I will insta-member you!

query planner uses genetic algorithm to optimise order of joins when too many tables are involved

That’s right. I forget the approximate number of join relations where more time planning surpasses likely execution but it’s like hundreds, right?

I think its at a dozen of joins or so.
But this is where I feel postgres lacks, oracle and ms have really good optimisations around performance.