simon godden wrote:
On 10/4/06, Richard Huxton <dev@xxxxxxxxxxxx> wrote:simon godden wrote: From psql, a "show all" command will list all your config settings and let you check the lc_xxx values are correct.lc_collate is C, as are all the other lc settings. I have run the analyze commands. Still the same.
Can you post EXPLAIN ANALYSE for the LIKE and <> queries that should be using the index? With enable_seqscan on and off please.
-- Richard Huxton Archonet Ltd
