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