Postgres Pro
Downloads
Home   >   mailing lists

Re: Ignored btree indexes on particular tables. - Mailing list pgsql-general

From William Temperley
Subject Re: Ignored btree indexes on particular tables.
Date
Msg-id 439dc11e0712110907s157fa779wa8f18d14f44df78c@mail.gmail.com
Whole thread Raw
In response to Re: Ignored btree indexes on particular tables.  (Richard Huxton <dev@archonet.com>)
Responses Re: Ignored btree indexes on particular tables.
List pgsql-general
Tree view
Genius!

Thanks Richard,

The old locale was C and the new one English_United Kingdom.1252

I created a new index with "varchar_pattern_ops" and off it went!

> the strange thing is my btree indexes on the uk roads data work fine.

Do they use like, or explicit range-checks?

I wasn't using like, which is why they were working. adding a new index then using the like operator didn't work.

Thanks again.

Will



pgsql-general by date:

Previous
From: "Gregory Williamson"
Date:
Subject: Re: Hijack!
Next
From: "Joshua D. Drake"
Date:
Subject: Re: top posting