Search Postgresql Archives

Locale setting advice

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

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?

Cheers,

FT

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux