| From: | Joel Matthew <rees(at)ddcom(dot)co(dot)jp> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Datatype sizes; a space and speed issue? |
| Date: | 2004-06-23 05:43:06 |
| Message-ID: | 20040623143108.EA3D.REES@ddcom.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> We used to have some attempts at optimizing on the assumption that
> char(n) fields were physically fixed-width, but we gave it up as a
> bad job several major releases back ... it was never more than a
> very marginal optimization anyway ...
Does that mean that PostGreSQL fixes character width at thirty-two bits,
or that it uses UTF-8, or that it just stores what it gets?
(Checked chapter 8.3 in the manual, didn't see the answer there. Not
that I really want to know. With Unicode, trying to optimize record
sizes for char/text fields is a little like trying to play Russian
Roulette. Wait, is that no longer politically correct? Should it be
called six-chamber roulette, now? Don't want to offend anyone.)
--
Joel Matthew <rees(at)ddcom(dot)co(dot)jp>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Matthew | 2004-06-23 05:54:29 | Re: Datatype sizes; a space and speed issue? |
| Previous Message | Madison Kelly | 2004-06-23 05:37:03 | Re: Datatype sizes; a space and speed issue? |