Skip site navigation (1) Skip section navigation (2)

Re: Abnormal performance difference between Postgres and MySQL

From: Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Farhan Husain <russoue(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Abnormal performance difference between Postgres and MySQL
Date: 2009-02-23 23:33:33
Message-ID: 1d4e0c10902231533t1b3731cdnda3adff7dd9811bb@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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:
>
> 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.

An EXPLAIN ANALYZE output would be nice to diagnose the problem.

-- 
Guillaume

In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2009-02-23 23:33:49
Subject: Re: postgreSQL performance 8.2.6 vs 8.3.3
Previous:From: Farhan HusainDate: 2009-02-23 23:33:06
Subject: Re: Abnormal performance difference between Postgres and MySQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group