Test/Sample database to use for testing? (switching to postgres vs mysql + Sphinx)


We’re looking to change or upgrade our DBMS in order to make searching faster in our RT installation. After trying three or four different ways to re-compile MySQL with SphinxSE, I somewhat gave up and installed PostgreSQL instead. To that end, converting between MySQL and Postgres is… problematic. I’d like to get some kind of data into our new database to test the search capabilities, to at least determine if the performance is better…

Anyway, so is there a sample Postgres database that I could import and do some searches against?


Johnathan Bell
Internet System Administrator, Baker College
Office Hours: 7A-4P Eastern, M-F