From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org, pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: [pgsql-performance] Large databases, performance |
Date: | 2002-10-08 05:44:11 |
Message-ID: | 3DA2BE03.3674.13CF7DD1@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-performance pgsql-sql |
On 7 Oct 2002 at 11:21, Tom Lane wrote:
> "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> writes:
> > I say if it's a char field, there should be no indicator of length as
> > it's not required. Just store those many characters straight ahead..
>
> Your assumption fails when considering UNICODE or other multibyte
> character encodings.
Correct but is it possible to have real char string when database is not
unicode or when locale defines size of char, to be exact?
In my case varchar does not make sense as all strings are guaranteed to be of
defined length. While the argument you have put is correct, it's causing a disk
space leak, to say so.
Bye
Shridhar
--
Boucher's Observation: He who blows his own horn always plays the music several
octaves higher than originally written.
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2002-10-08 05:47:18 | Re: [HACKERS] Hot Backup |
Previous Message | Tom Lane | 2002-10-08 03:00:37 | Re: PLTCL return_null crash... |
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2002-10-08 05:47:18 | Re: [HACKERS] Hot Backup |
Previous Message | Neil Conway | 2002-10-08 04:58:34 | Re: inline newNode() |
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2002-10-08 07:20:47 | Re: [pgsql-performance] Large databases, performance |
Previous Message | Martijn van Oosterhout | 2002-10-08 00:03:08 | Re: sloooow query |
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2002-10-08 07:20:47 | Re: [pgsql-performance] Large databases, performance |
Previous Message | gordoncl | 2002-10-08 02:14:10 | Probs "compiling" a function |