[rt-users] Upgrade and migration questions

[Dominic Hargreaves]

On Tue, Jan 26, 2010 at 02:12:34PM -0600, Kenneth Marshall wrote:

> Moving from PostgreSQL -> MySQL will need a little bit more work.
> I think that there is a wiki article and possibly some tools to
> help with this process. I do have a question for you. Why are you
> moving from PostgreSQL to MySQL instead of updating to the current
> PostgreSQL release? For one thing, PostgreSQL will allow you to
> use full text indexing to dramatically improve the performance of
> full content searching within your tickets and RTFM articles.
> This functionality is also available with the Oracle backend. Is
> there some problem you are trying to address?

Just to note that I assume you're talking about 
<http://wiki.bestpractical.com/view/PostgreSQLFullText> which isn't
a standard part of RT yet; I wondered for a while after reading your
message whether I'd missed something!

It's a shame that the API for SearchBuilder isn't such that you can
configure to treat certain columns as full-text-searchable ones rather
than have to manually hack it in; makes deployment a little more
fiddly.

But thanks for mentioning it because I didn't realise that this work
had been done and it's something we're interested in!

-- 
Dominic Hargreaves, Systems Development and Support Team
Computing Services, University of Oxford
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100127/87cd110a/attachment.sig>