From: | "Dean Gibson (DB Administrator)" <postgresql(at)ultimeth(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: 8.3.0, locales, and encodings |
Date: | 2008-02-07 16:32:39 |
Message-ID: | 47AB32A7.6050406@ultimeth.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 2008-02-07 01:17, Tino Schwarze wrote:
> Hi Dean,
>
> On Wed, Feb 06, 2008 at 06:29:02PM -0800, Dean Gibson (DB Administrator) wrote:
>
>> 2. ... Should I be running INITDB w/ "-locale POSIX -E UTF8", or just "-locale POSIX" (implying "-E SQL_ASCII")? Or does it make a difference, since I always specify the desired database encoding when I "CREATE DATABASE... ENCODING '...';"?
>>
>
> AFAIK, it shouldn't make a difference. -E is just the default encoding for new databases.
>
>
Actually, "-E" also affects the encoding of the base PostgreSQL
databases. W/o "-E":
=> \l
List of databases
Name | Owner | Encoding
-----------+----------+-----------
postgres | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
If I INITDB /w "-E UTF8":
=> \l
List of databases
Name | Owner | Encoding
-----------+----------+----------
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8
So, the interesting question is, does the difference in the encoding of
the base databases affect performance or capability in any way?
-- Dean
From | Date | Subject | |
---|---|---|---|
Next Message | Dimitri Fontaine | 2008-02-07 19:01:12 | Re: Where to find information on the new HOT tables? |
Previous Message | Michael Monnerie | 2008-02-07 15:52:35 | Re: Where to find information on the new HOT tables? |