On Mon, Feb 23, 2009 at 4:33 PM, Guillaume Smet <guillaume.smet@xxxxxxxxx> wrote: > On Tue, Feb 24, 2009 at 12:27 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: >> If it's not C then string compares are going to probably need special >> indexes to work the way you expect them. (varchar pattern ops). Look >> here for more information: >> >> http://www.postgresql.org/docs/8.3/static/indexes-opclass.html > > It's only relevant for pattern matching (eg LIKE or regexp). AFAICS, > the OP only uses plain equals in his query. True, I had a bit of a headache trying to read that unindented query. (OP here's a hint, if you want people to read your queries / code, indent it in some way that makes it fairly readable Note that varchar_pattern_ops indexes can't be used for straight equal compares either. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
