Re:PostgreSQL is Engine Yard's New Default
by astrodust on Thursday August 16, 2012 @01:21AM
(#4390010)
The other way is to have an InnoDB master table with MyISAM derivatives kept in sync by triggers. Ugly but effective.
It's been way too long for InnoDB to be without that type of index.
InnoDB master. MyISAM slaves.