| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Herouth Maoz" <herouth(at)unicell(dot)co(dot)il> |
| Cc: | "Jeff Janes" <jeff(dot)janes(at)gmail(dot)com>, "Craig Ringer" <ringerc(at)ringerc(dot)id(dot)au>, pgsql-general(at)postgresql(dot)org, tv(at)fuzzy(dot)cz |
| Subject: | Re: Index creation takes more time? |
| Date: | 2012-09-18 13:52:11 |
| Message-ID: | 14600.1347976331@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Herouth Maoz" <herouth(at)unicell(dot)co(dot)il> writes:
> So, I must, at this point, draw the conclusion that string comparison is a much, much heavier task in utf-8 than it is in an 8-bit encoding - or that the collation is the problem.
Going from "C" collation to anything else is generally a huge hit in
terms of string comparison/sorting performance. Do you really need
locale-aware sorting, or just enforcement of utf8 encoding? Because you
can use "C" locale with any encoding.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | António Rodrigues | 2012-09-18 14:06:34 | Re: Move table - New schema |
| Previous Message | Adrian Klaver | 2012-09-18 13:37:39 | Re: Move table - New schema |