On Tue, Feb 24, 2009 at 12:27 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> 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:
It's only relevant for pattern matching (eg LIKE or regexp). AFAICS,
the OP only uses plain equals in his query.
An EXPLAIN ANALYZE output would be nice to diagnose the problem.
In response to
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2009-02-23 23:33:49|
|Subject: Re: postgreSQL performance 8.2.6 vs 8.3.3|
|Previous:||From: Farhan Husain||Date: 2009-02-23 23:33:06|
|Subject: Re: Abnormal performance difference between Postgres and MySQL|