Don Seiler <don@seiler.us> writes: > Actually, would I need to re-index on text columns that we know contain > UUID strings? UUID characters seem to be pretty basic alphanumeric ASCII > characters.
I think you're all right with respect to those, since they're the same under any encoding. It's columns containing non-ASCII characters that you'd want to worry about reindexing.
Follow-up question, the locale setting on the host would still be set to en_US (as would the postgres and template0 databases). Should I look to change that locale on the system to en_US.UTF-8, or even just for the postgres user that the DB cluster runs as? What are the ramification for doing (or not doing) so?
