I've heard that doing indexes on CHAR(n) and VARCHAR(n) fields are dog
slow. But that's mainly been with the commercial databases- Sybase and
Oracle. Is this true with Postgres as well?
Or, to put it more specifically, is it true enough that it is worthwhile
for me to calculate the hash values of the CHAR fields and put the index
there (I don't need to do selects using 'LIKE'). This means more
complexity and higher maintainance than just slapping an index on the
string field.
Thanks,
Brian