Optimise huge Postgres table for fast read
Add a second column which will hold a hash of the text value.  Create the index on the hash.  Even if there is a hash collision there will be only a few rows to read and perform a full comparison on the text vlaues.