On Mon, Feb 23, 2009 at 4:33 PM, Guillaume Smet <[email protected]> wrote: > On Tue, Feb 24, 2009 at 12:27 AM, Scott Marlowe <[email protected]> > 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
