Skip site navigation (1)
Skip section navigation (2)
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 varchar_pattern_ops
Peripheral Links
Header And Logo
|
Site Navigation
difference between a unique constraint and a unique index ???
- From: Dave Cramer <pg(at)fastcrypt(dot)com>
- To: postgresql performance list <pgsql-performance(at)postgresql(dot)org>
- Subject: difference between a unique constraint and a unique index ???
- Date: Mon, 12 Nov 2007 09:51:30 -0500
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 varchar_pattern_ops
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 ? Dave
- Follow-Ups:
- Re: difference between a unique constraint and a unique index ???
- From: Alvaro Herrera
- Re: difference between a unique constraint and a unique index ???
- Prev by Date: Re: PostgreSQL vs MySQL, and FreeBSD
- Next by Date: Re: difference between a unique constraint and a unique index ???
- Previous by thread: Clustered/covering indexes (or lack thereof :-)
- Next by thread: Re: difference between a unique constraint and a unique index ???
- Indexes: