In order to get like queries to use an index with database initialized
with a UTF-8 character set I added a unique index to a table with a
This table already had a unique constraint on the column so I dropped
the unique constraint.
I can't give exact measurements however this caused my application to
slow down considerably.
The only thing I can figure is that the varchar_pattern_ops operator
is significantly slower ???
Is there some other piece of the puzzle to fill in ?
pgsql-performance by date
|Next:||From: Alvaro Herrera||Date: 2007-11-12 14:56:30|
|Subject: Re: difference between a unique constraint and a uniqueindex ???|
|Previous:||From: Shane Ambler||Date: 2007-11-12 10:23:13|
|Subject: Re: PostgreSQL vs MySQL, and FreeBSD|