| From: | Finn MacCool <fintan(dot)taliesin(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Locale setting advice |
| Date: | 2010-12-19 23:48:25 |
| Message-ID: | AANLkTi=jP2=g-AzptPMVPvJwqh7zJaWoh7igB7AAB6Vo@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wang, Mary Y | 2010-12-20 01:05:57 | Need More Case Studies on PostGIS |
| Previous Message | Glenn Maynard | 2010-12-19 20:26:05 | Re: FTS phrase searches |