FullText Searching: The Dilemma
mkanat at bugzilla.org
Tue Jun 26 23:14:50 UTC 2007
On Tue, 26 Jun 2007 15:34:09 +0100 Gervase Markham <gerv at mozilla.org>
> We could do that. How hard would it be to convert b.m.o.? Are there
> scripts, or do all conversions have to be done by hand? Do we know
> how MoCo IT would feel about supporting Postgres? Do we feel the
> Postgres support is stable enough? Are there other downsides?
We actually talked about it during the last upgrade, I believe.
The problem is that currently PostgreSQL is case-sensitive for
searches, which is too much of a pain.
If there was a way to make the whole DB use a case-insensitive
search and collation (and still be able to use indexes), we could do
Competent, Friendly Bugzilla Services. And Everything Else, too.
More information about the developers