I'm about to upgrade a 700GB 8.4 db to version 9.0.2, and I'm curious if there is any benefit to switching from my current lc_collate setting of "en_US.UTF-8" to C. I read over the docs a couple times, but couldn't really find anything conclusive other than the statement that settings other than C have negative performance impacts. We do store UTF8 data, but I assume that that is handled by creating the db with the encoding of UTF8.
Are there any other details I can provide to elicit feedback?