David Gerard wrote:
Previous efforts in this direction have worked well in testing on Postgres, but foundered on MySQL not being up to the task. Since the chance of Wikimedia moving off MySQL is about zero, a solution that works on MySQL would be *wonderful*.
There's no need to move off MySQL in order to move on to PostgreSQL. We already have data stored in Lucene, Berkley DB and Memcached. Although it would be easier for system administration if we could use an existing installation of something, I certainly don't see it as a killer to a PostgreSQL solution.
But it seems to me, if you look at data storage software already in use, Lucene is much better suited for computing intersections than MySQL.
-- Tim Starling