Comment 19 for bug 119780

Revision history for this message
Eleanor Berger (intellectronica) wrote : Re: [Bug 119780] Re: GIN indexes cause some searches of bug comments to fail

On 28/01/2008, Björn Tillenius <email address hidden> wrote:
> On Mon, Jan 28, 2008 at 08:11:32AM -0000, Graham Binns wrote:
> > This bug has been cited by Stuart on-list as the cause for bug #186262
> > (whether that makes the latter bug a dupe of this one I'm not sure).
>
> No, it's not a dupe. This bug is about searching comments, while bug
> #186262 is about searching in the bug description. I don't think there's
> a single fix which will fix both cases.

I wonder whether it's worth (and at all possible) to maintain both GIN
and GiST indexes, the latter not including comments, and fall back to
searching the GiST (but not the comments) if the searching the GIN
indexes proves impossible. Then again, this may be a bad idea, if only
because of the complexity involved.