On 04.09.2010, 0:33 OQ wrote:
I also was going through the schema and noticed there was a decent disparity between table indexes on what is indexed and what the indexes cover wrt MySQL and Postgres.
This is generally OK because different databases may use different strategies when executing the same query. Of course, this means case-by-case analysis for every discrepancy.