[rt-users] Content searching takes a long time and runs multiple queries

[Kenneth Marshall]

On Sat, Dec 11, 2010 at 09:35:26AM +0000, Justin Hayes wrote:
> Thanks Ken. I certainly prefer the idea of using inbuilt DB server functionality to improve performance than an external tool hooked in.
> 
> I'll probably look into a PostgreSQL migration first and see where that takes me. I hope it's *just* a case of creating the schema by running a 3.8.8 install against it, dumping the data and loading it in ;)
> 
> Justin
> 

The migration should be pretty straightforward. There is a wiki page on it:

http://requesttracker.wikia.com/wiki/MySQLToPg

There are a number of methods that people have used for the migration. I would
probably use the dump/restore method and then create a second version using the
connect to both DBs at once and transfer the data. Then I would compare the
resulting DBs. They should be the same. :)

Ken