The second one will take a while, and it is possible for it to fail if there are records with fields greater than 2.7k and Postgres was not adjusted at compile time to increase the page size.
Doh! ERROR: index row size 4232 exceeds btree maximum, 2713 HINT: Values larger than 1/3 of a buffer page cannot be indexed.Consider a function index of an MD5 hash of the value, or use full text indexing.
I believe you noted to me previously that this requires an initdb after the recompile?
