Re: [PERFORM] B-Tree index not being used

2005-07-02 Thread Tom Lane
Madison Kelly [EMAIL PROTECTED] writes: Can anyone see why the index might not be being used? You didn't initdb in 'C' locale. You can either re-initdb, or create a specialized index with a non-default operator class to support LIKE. See the documentation. regards,

Re: [PERFORM] B-Tree index not being used

2005-07-02 Thread Madison Kelly
Tom Lane wrote: Madison Kelly [EMAIL PROTECTED] writes: Can anyone see why the index might not be being used? You didn't initdb in 'C' locale. You can either re-initdb, or create a specialized index with a non-default operator class to support LIKE. See the documentation.