Or are the two basically the same when it comes to figuring out how to build the right indexes?
closed as not constructive by ChrisF♦ Jan 20 '12 at 11:46
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.
MySQL's one better for MySQL and Postgres' one is better for Postgres.
Both databases' internals differ a lot, so the outputs of their respective EXPLAINs are constructed in a way that tells most about how each of them deals with given query.