Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > How are people going to know to use these special LIKE indexes?
>
> The same way they presumably find out about anything else: RTFM. A couple
> of more cross-references and index entries need to be added, though.
Well, this isn't one of those, "How do I do X" but rather something they
will only know they need if they wonder why their LIKE queries are slow
--- that isn't going to be obvious to too many people. An FAQ may be
required for this --- fortunately we already have an item for indexes.
That is one thing I liked about the initdb mention --- it clearly told
them to watch out for something they might not have been looking for.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073
