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 specific 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, see the FAQ for guidance.
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.